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
 
Back
Top