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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
"circular" concentric charts - like a pilot's plotting/nav computer 1
How do I chart contours in Excel 2007? 2
Surface chart - number of catergories 1
Surface Chart/Contour Chart options 4
Combining a Surface Chart With a Scatter Plot 1
How to create a bubble chart with more than 2 variables 0
How do I plot "" as empty rather than zero in a chart 1

Back
Top