Microsoft Office Tutorials and References
In Depth Information
Controlling a Data Series by Hiding Data
clearly misleading. In the bottom chart, the missing data is interpolated. Because of the time-based
and relatively smooth nature of the data, interpolating the missing data may be an appropriate
Figure 6-15: These three charts depict the three ways to present missing data in a chart.
For line charts, you can force Excel to interpolate missing values by placing =NA() in the
empty cells. Those cell values will be interpolated, regardless of the missing data option
that is in effect for the chart. For other charts, =NA() is interpreted as zero.
Controlling a Data Series by Hiding Data
By default, Excel doesn’t plot data that is in a hidden row or column. You can sometimes use this to
your advantage because it’s an easy way to control what data appears in the chart.
Figure 6-16 shows a line chart that plots 365 days of data stored in a table (created by choosing
Insert Tables Table). Figure 6-17 shows the same chart after I applied a filter to the table. The filter
hides all rows except those in which the month is September.
In some cases, when you’re working with outlines or filtered tables (both of which use hidden rows),
you may not like the idea that hidden data is removed from your chart. To override this, activate the
chart and choose Chart Tools Design Data Select Data to display the Select Data Source dialog
box. Click the Hidden and Empty Cells button and select the Show Data in Hidden Rows and Columns
check box.
Search JabSto ::

Custom Search