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

Part 6. Working with Charts > Changing the Chart Source Data

Changing the Chart Source Data

Right-click your current chart and select Copy from the shortcut menu that appears. This will copy the chart exactly.

Switch to the worksheet or open the file containing the new source data, right-click, and select Paste from the shortcut menu that appears.

Right-click the pasted chart and select Source Data.

INTRODUCTION

Suppose you just finished creating your chart in exactly the way you intended it, and your boss tells you that the data he gave you was incorrect, and hands you a file with the corrected data on it. Was all the time you spent on your chart for nothing? Of course not! Simply tell Excel what you want the new data source to be, and you are ready to go.


TIP

Adding and excluding data

Changing the chart source data is similar to adding or excluding data from your chart. See the task that follows for more information on altering the source data within your worksheet.


Excel jumps to the original data-source worksheet. If the source data workbook is not open, the Data range field in the Source Data dialog box will appear blank.

Click and drag to select the new data source cells (for example, from five products to three); simultaneously, the Source Data dialog box shrinks to show the data.

When you release the mouse button, the Data range list box in the Source Data dialog box displays the new source data range; click OK.

The chart is updated to reflect the new data source. If you need to change some chart options, refer to the task “Altering Chart Options” earlier in this part.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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