XL5: Maximum Data Series Error with Plot Visible Cells On

Last reviewed: September 12, 1996
Article 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:

Select the range of data and choose Goto from the Edit menu and then choose the Special button.
In the Go To Special dialog box, select the Visible Cells Only check box and choose OK.
From the Edit menu, choose Copy.
Select a cell in the same column as, but below, the data.
From the Edit menu, choose Paste.
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

KBCategory: kbprb
KBSubcategory:
Additional reference words: data series 5.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: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.