Microsoft KB Archive/213980

= XL2000: Data Map Charts Use Hidden Rows and Columns =

Article ID: 213980

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213980





SYMPTOMS
Map charts use data contained in hidden or filtered rows and columns. This behavior is different from a normal data chart created in Microsoft Excel.



CAUSE
When you create a chart in Microsoft Excel 2000, any rows or columns that have been hidden, or rows that have been filtered that are part of the chart's selected data range, do not appear in the chart. However, when you create a map chart in Microsoft Excel, all rows and columns that are in the data range are included in the map regardless of whether they are hidden or filtered.



WORKAROUND
To work around this behavior, you must select only the visible cells in the data range that you want to chart. To select only the visible cells, follow these steps:
 * 1) Select the range of cells for which you want to create a data map.
 * 2) Click Go To on the Edit menu. In the Go To dialog box, click Special.
 * 3) In the Go To Special dialog box, click Visible cells only, and then click OK.

Only the visible cells within the range will be selected. A data map created with the currently selected cells will not use data from the hidden rows.

Additional query words: XL2000

Keywords: kbprb KB213980

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.