Here is the most common question when it comes to chart – After a chart is created, I often find that I’ve forgotten to add a row or column of data. Do I have to create a whole new chart to add in this missing data?
Thankfully, the answer to this question is “NO.” It’s really a simple matter of Copy & Paste.
Select the data you want to add to your chart
Choose Copy on the Standard toolbar
Select your chart
Choose Paste on the Standard toolbar