How to I get a surface chart to ignore empty cells?

G

Guest

How do I get a surface chart to plot empty cells in white rather than in the
colour that the chart uses to display 0 values?
 
B

Bernard Liengme

IN the cell enter =NA() rather than just an empty space
best wishes
Bernard
 
T

Tushar Mehta

Unfortunately, you cannot. XL's surface chart has very limited
formatting and other capabilities. Unlike several other chart types, a
surface chart will not ignore empty cells or #N/A values. Instead, it
will treat them as zeros.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

surface chart 1
Surface Chart/Contour Chart options 4
How do I chart contours in Excel 2007? 2
How do I plot "" as empty rather than zero in a chart 1
How to create a bubble chart with more than 2 variables 0
How do I disable "Plot visible cells only" when it is greyed out? 1
Combining a Surface Chart With a Scatter Plot 1
A tough question? - about surface plots 8

Top