Microsoft KB Archive/37999

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:55, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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





SUMMARY

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.



MORE INFORMATION

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.