Copy and paste it! Say you have a chart with the months on the x-axis (horizontal). As you add a new month to the data table, you can select the applicable column (or columns to add several months) and copy. Be sure to include the column title. Then select your chart and paste. Your chart should include the new data.
You can do this across workbooks and worksheets. Be sure to structure the data the same as the original chart data to avoid unpleasant surprises! Undo (Ctrl+Z) works fine here if you make a mistake.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/37545/need-to-add-data-to-your-excel-chart "