Timesaving Techniques for Adding or Editing Chart Data

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 ...

Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.