Microsoft Office Tutorials and References
In Depth Information
CHART FILTERED DATA
With Excel, you can quickly create a chart showing
the information in a worksheet or list. Charts show
trends and anomalies that may otherwise be difficult
to detect in columns of numbers. By choosing the
appropriate type of chart and formatting chart
features, you can share your results with others and
convey patterns in your data. For more about
charting, see Chapter 6.
To create a chart, select the data you want to chart,
click the Insert tab, and then click a chart type.
Excel creates a chart. You can position your chart
next to the data on which you base it, so when
you change the data you can instantly observe the
changes in the chart.
By default, as you filter your data, Excel removes the
filtered data from your chart. If you do not want
Excel to remove filtered data, select the Show Data
in Hidden Fields option in the Hidden and Empty Cell
Settings dialog box.
Create a chart.
Note: See Chapter 6 for detailed
information on creating charts.
Filter the data on which the
chart is based.
Note: See previous tasks in this
chapter to learn more about
A filter button on the down
arrow indicates that you have
By default, only the unfiltered
data displays in the chart.
Click your chart.
l The chart tools become available.
Click the Design tab.
Click Select Data.