XL5: Maximum Data Series Error with Plot Visible Cells On

ID: Q110974

5.00 WINDOWS kbprb

The information in this article applies to:

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.

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.

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

"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

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996