Editing or Adding a Data Series to a Chart

Data for example:

  1. Click the chart to which you want to add another data series. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  1. On the Design tab, in the Data group, click Select Data.

  1. In the Select Data Source pop up box, under Legend Entries (Series), click Add.

  1. In the Edit Series pop up box, do the following:
  • In the Series name box, type the name that you want to use for the series, or select the name on the worksheet. In this example select cell C6.

  • In the Series values box, type the reference of the data range of the data series that you want to add, or select the range on the worksheet. In this example highlight cells C7 through C11.

  1. Click on “OK”. In the Select Data Source pop up box click on OK again.

Share
This entry was posted in Editing Charts & Graphs. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


7 × two =