If you have ever created a Chart that needed Updating on a regular basis, you know what a bore it can be to do the frequent revisions. That sort of work may keep some people employed, but there are Better Ways to handle this task.
Building a Self-Expanding Chart is remarkably simple, and can Save You A Good Deal Of Time and boredom (and, after all, who needs more boredom!)
To create your Self-Expanding Chart in Excel 2007 or versions thereafter, here is what you do:
1. Create your Chart as usual ( you can use the sample data below)
2. Select any cell that contains the data that is used by the chart
3. Choose Insert / Tables group / Table to convert the range to a table
Amazingly that’s all there is to it! Excel will recognize the data as a Table and any data that is added to it is Automatically Updated in the Chart.
Give this Charting Trick a try, and find out why it is such a Treat!
No comments:
Post a Comment