Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to get Excel to ignore holes in your data
- Thread starter litho
- Start date
Control the way empty cells are plotted in a chart
Click the chart.
On the Tools menu, click Options, and then click the Chart tab.
Under Plot empty cells as, click the option you want.
For Help on an option, click the question mark and then click the option.
you will want interpolated...
good luck
Click the chart.
On the Tools menu, click Options, and then click the Chart tab.
Under Plot empty cells as, click the option you want.
For Help on an option, click the question mark and then click the option.
you will want interpolated...
good luck
- Thread starter
- #3
Hi
Thansk for the advice. It does not seem to work with a surface plot in 3 D. Any empty cells appear to be plotted as zero no matter what it is set to..
It works with a simple plot, for example a scatter plot that you plot with lines joining the dots.
Thansk for the advice. It does not seem to work with a surface plot in 3 D. Any empty cells appear to be plotted as zero no matter what it is set to..
It works with a simple plot, for example a scatter plot that you plot with lines joining the dots.
- Status
Similar threads
- Locked
- Question
