Customizing Chart Data

Whenever you create a chart for a business, there’s always the possibility that the data displayed in the chart will change. Whether those changes reflect continuing sales, updated values that account for returns and inventory charges, or investment projections revised to match market conditions, you can update your chart by identifying a new data source. The data can be in any workbook on your computer or network—all you need to do is identify the cells with the data, and Excel will do the rest.

Change the Source Data for Your Chart

  1. Click the chart you want to change.

  2. Click the Design tab.

  3. Click Select Data.

  4. Click in the Chart Data Range field.

  5. Select the cells you want to provide the new source data.

  6. Click OK.

    Change the Source Data for Your Chart

Add a New Series

  1. Click the chart you want to change.

  2. Click the Design tab.

  3. Click Select Data.

  4. Click Add.

  5. Type the name you want to assign to the series.

  6. Click in the Series Values field.

  7. Select the cells you want to add.

  8. Click OK to close the Edit Series dialog box.

  9. Click OK to close the Select Data Source dialog box.

    Add a New Series
    Add a New Series
    Add a New Series

    Tip

    Tip

    You can also type the address of the cell that contains the series name you want to use in the chart.

Delete a Series

  1. Click the chart you want to change.

  2. Click the Design tab.

  3. Click Select Data.

  4. Click the name of the series you want to delete.

  5. Click Remove.

  6. Click OK.

    Delete a Series
    Delete a Series
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.219.239.118