XL5: Maximum Data Series Error with Plot Visible Cells On

ID: Q110974

The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0

SYMPTOMS

When you create a chart from a range of data that includes hidden rows, you may receive the following error message

Maximum number of data series per chart is 255
even though the option to Plot Visible Cells Only is selected.


WORKAROUND

To plot data in a range of cells greater than 255 rows, do the following:

  1. Select the range of data and choose Goto from the Edit menu and then choose the Special button.


  2. In the Go To Special dialog box, select the Visible Cells Only check box and choose OK.


  3. From the Edit menu, choose Copy.


  4. Select a cell in the same column as, but below, the data.


  5. From the Edit menu, choose Paste.


  6. With the new range of cells selected, plot the chart.



STATUS

Microsoft is researching this problem and will post new information here as it becomes available.


REFERENCES

"User's Guide," version 5.0, Chapter 15

For more information about Charting Specifications, choose the Search button in Help and type:

charts

Additional query words: data series

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :


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