Adding an Additional Category to an Excel Chart

 Last reviewed: July 18, 1996
Article ID: Q49137
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, versions 2.2, 3.0

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)

  • 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.

  • 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."

    • KBCategory: kbusage
    KBSubcategory:

    Additional words: 2.0 2.00 2.1 2.10 2.2 2.20 2.21 3.0 3.00
    4.0 4.00 5.0 5.00

    THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

    Last reviewed: July 18, 1996
    © 1998 Microsoft Corporation. All rights reserved. Terms of Use.