Microsoft KB Archive/49137

From BetaArchive Wiki

Adding an Additional Category to an Excel Chart



The information in this article applies to:


  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.x, 5.x, 7.0, 7.0a
  • Microsoft Excel for OS/2





SUMMARY

Microsoft Excel 5.0 and 7.0

To add a new data series in version 5 or 7 you could:

1) Highlight the new series of data.
2) Choose the Edit menu and select Copy.
3) Activate the chart by double clicking on it.
4) Choose the Edit menu and select Paste Special.
5) Select "Add cells as New Series" and click OK.

You could also:

1) Double click on the chart then choose the Insert menu.
2) Choose Select New Data.
3) Click in the range box and highlight the new range on the worksheet or type in the range of the new series.
4) In the Paste Special dialog box, select "Add cells as New Series" and click OK.




Microsoft Excel 3.0 4.0

To add a new category to an existing chart, you can choose Edit Series from the Chart menu. To view the Chart menu, double click on a chart series.


Microsoft Excel 2.x

To add a new category to an existing chart, you must manually edit each series formula of the chart by doing the following:


  1. Increase the ending range of the category argument by one.
  2. Increase the ending range of the value argument by one.

The modifications for each series depends on whether the chart was created using data organized in rows or columns.

In the following examples, the formulas' arguments are in the following order:


   =SERIES(series name,category argument,values argument,order) 




  1. Data Organized in Rows


=SERIES(SHEET1.XLS!$B$1,SHEET1.XLS!$A$2:$A$4,SHEET1.XLS!$B$2:$B$4,1)

Increase $A$4 (in the category argument) to $A$5 and increase $B$4 (in the value argument) to $B$5.

  1. Data Organized in Columns


=SERIES(SHEET1.XLS!$A$8,SHEET1.XLS!$B$7:$E$7,SHEET1.XLS!$B$8:$E$8,1)

Increase $E$7 (in the category argument) to $F$7 and increase $E$8 (in the value argument) to $F$8.

For further information on series formulas, refer to the "Series Formula" section in the "Microsoft Excel Reference" manual or the "Microsoft Excel User's Guide."

Additional query words:

Keywords :
Version : WINDOWS:2.x,3.0,4.x,5.x,7.0,7.0a; :
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: January 4, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.