Monday, February 25, 2008

How do I add another series into a chart in Excel?

Sometimes you may need to add another data series into a chart you have already created. Below I have created the chart with January and February data when the March figures came in. How do I add this information to the chart too? There are a couple of ways of going about it. Let's take a look.



View the video demonstration below or scroll down for written directions on how this is done in Excel 2007.

Method 1:

If the data you want to include is located next to your other data series, click onto the chart to select it. You will notice that a blue outline will appear around the data series. Simply drag the blue outline to include the new data.

Method 2:

If it is not practical to use mthod 1 (maybe you want a data series not located next to the anothers), click into the chart and right click to bring up the menu. Select data > Add. Enter the relevant information. The optional series name usually will refer to the column heading. You can then choose the series value by highlighting the range of data you want to include.

That's all there is to it.

1 Comment:

Anonymous said...

Thats ok if the data you want is in the same format as what the original map is, if you need to put dates in how do you do that!