• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 26. Working with Chart Data > Changing or Replacing Data

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint