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

ID: Q37999

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:

Use the arrow keys to select series 1 (you will see "S1P1" in the cell-reference area of the formula bar).

Modify the references in the series formula to include the new data.

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        :

Last Reviewed: March 12, 1999