Microsoft KB Archive/37999

From BetaArchive Wiki

Adding Data Points to a Type 8 Line Chart in Windows Excel

The information in this article applies to:

  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0


If you want to add data to a high-low-average line chart (type 8) in Excel without re-creating the chart, you must modify three different series formulas by editing the series formulas in the formula bar, or when using version 3.0, by using the Edit Series command from the Chart menu.


To edit using the formula bar, do the following:

  1. Use the arrow keys to select series 1 (you will see "S1P1" in the cell-reference area of the formula bar).
  2. Modify the references in the series formula to include the new data.
  3. Press the ENTER key.

Use the arrow keys to select Series 2 and Series 3 and change them in the same manner. The new chart will show the extra categories and high-low lines.

Additional query words:

Keywords :
Version :
Platform :
Issue type :
Technology :

Last Reviewed: March 12, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.