March 2007
Intermediate to advanced
704 pages
21h 31m
English
As mentioned earlier, when you format your source data as a table, you gain benefits for the chart, such as the chart automatically updating to reflect changes in the source data range. So, you probably won’t need to make as much use of shortcuts for adding data to your chart as you might have in the past. However, using a table in this way isn’t always practical—such as when your chart needs to be created from noncontiguous data or your table organization doesn’t lend itself to being in a table. With this in mind, following are two helpful methods for adding data to a chart.
When your data is not in an Excel table and the new series you want to add has exactly the same configuration as existing ...
Read now
Unlock full access