Excel: Adding a New Series to an Existing Chart

 Last reviewed: November 29, 1994
Article ID: Q57190

SUMMARY

Information can be added to an existing Microsoft Excel chart by using the Paste command without creating a new chart. To add a new series to an existing chart, do the following:

  1. Activate the worksheet.

  2. Select the range containing the information to be added.

  3. From the Edit menu, choose Copy.

  4. From the Window menu, choose the existing chart to make the chart active.

  5. From the Edit menu, choose Paste.

  6. Click the OK button.

A new series will appear in the chart, and if a legend is present, a new entry appears in the legend. If you need to control the data plotting, use the Paste Special command instead of Paste, and select the options you want.

An alternative method to add a new series to an existing chart in Excel 4.0 only, is by using the ChartWizard tool button. Do the following with the existing chart active:

  1. Press the ChartWizard tool button.

  2. Modify the reference in the Range edit box to include the new range of cells,

  3. Press the Next> button and then press OK.

The existing chart will update to include the new set of data points.

For more information about Excel data series, see page 402 of the "Microsoft Excel User's Guide 1," version 4.0 manual. If you are using version 3.0, see page 396 of the "Microsoft Excel User's Guide" version 3.0 manual. For more information about adding a data series from a worksheet, see pages 438-442 of the "Microsoft Excel User's Guide 1," version 4.0 manual. If you are using version 3.0, see pages 438-440 of the "Microsoft Excel User's Guide" version 3.0 manual.

KBCategory: kbusage
KBSubcategory:

Additional words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20
3.0 3.00 4.0 4.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: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.