O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Changing or Replacing Data

If you drag the lower or upper perimeter of a data-bounding rectangle, rather than its Fill handle, Excel moves both the start and endpoint of your series. This can be an effective way to obtain detailed views of a chart's data across the whole range of available data.

To switch to an entirely different set of data, select any part of your chart, and then choose Chart, Source Data. You can adjust the entire chart at once (all series) by using the Data Range box on the Data Range tab, or you can work with individual series on the Series tab.

Switch the data source to a PivotTable

In some earlier versions of Excel, you were not permitted to switch the data set from an ordinary worksheet table to a PivotTable. Not any more; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required