Microsoft Office Tutorials and References
In Depth Information
Controlling a Data Series by Hiding Data
Figure 3-18: These three charts depict the three ways to present missing
data in a chart.
You can force Excel to interpolate values by placing =NA() in the appropriate
cells. Those cell values will be interpolated, regardless of the missing data
option that is in effect for the chart.
Controlling a Data Series
by Hiding Data
Usually, 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.
In some cases, when you’re working with outlines or Autofiltering (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 select the Tools
command. In the Options dialog box, click the Chart tab and remove the checkmark
from the option labeled Plot Visible Cells Only.