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

Part 3. Using Excel > Task 30 How to Change the Chart Data

Task 30 How to Change the Chart Data

If you delete a column or row of data from a chart's source data table, the chart adjusts automatically. Nevertheless, if you add data to the source table (for example, if you add another month's sales figures), you must add the new data to the chart manually. If you have already created a highly formatted chart, and you want to use that chart to display a different source data table (instead of creating a new chart), you can change the chart's source data range in one of several ways.

  1. Select the Source Range

    Click the chart to select it. A colored border surrounds the source data.



  2. Drag the Border

    Click and drag the corner handle of the colored border to expand (or reduce) the source data range. For example, in this figure, I'm expanding the data range to include the first quarter sales results from Carver City.



  3. Release the Mouse Button

    As soon as you release the mouse button, the source data range is redrawn, and the chart now reflects the new data. Notice that the colored border now surrounds a larger data range than it did in Step 1.



  4. Use the Add Data Command

    Another method of adding new data to the chart is to use the Add Data command. Choose Chart, Add Data to open the Add Data dialog box.



  5. Select the New Data

    With the Add Data dialog box open, highlight the data in the worksheet that you want to add to the chart. (You can drag the Add Data dialog box out of the way if you need to; just click and drag its title bar.) After you select the data you want to add to the chart, its range is inserted into the Range text box in the Add Data dialog box.



  6. Add the Data

    Click OK to close the Add Data dialog box and add the new data to your chart.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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