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

D

davis494

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

How to Select Multiple Emails using Surface Pen 0
surface chart 1
Create a chart from a table in word thats dynamic 0
How do I chart contours in Excel 2007? 2
Surface chart - number of catergories 1
Surface Chart/Contour Chart options 4
Interval in legends in surface charts 8
A tough question? - about surface plots 8

Top