XL: Data Map Charts Use Hidden Rows and Columns

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel 97 for Windows

SUMMARY

In Microsoft Excel, 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.

When you create a chart in Microsoft Excel, 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 situation, you must select only the visible cells in the data range that you wish to chart. To select only the visible cells, follow these steps:

1. Select the range of cells that you want to create a data map from.

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 Visuble Cells Only, then click OK.