|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 6th, 2004, 04:17 PM
|
|||
|
|||
How to I get a surface chart to ignore empty cells?
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? 
|
|
#2
September 6th, 2004, 06:25 PM
|
|||
|
|||
|
IN the cell enter =NA() rather than just an empty space
best wishes Bernard "davis494" wrote in message ... 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?
|
|
#3
September 6th, 2004, 09:22 PM
|
|||
|
|||
|
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 In article , says... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to create stacked line chart with some empty value? | Jon Peltier | Charts and Charting | 0 | November 12th, 2003 06:35 PM |
| Multiple Conditional Formats for A Chart (Please Help)? | Jon Peltier | Charts and Charting | 0 | September 19th, 2003 09:40 PM |
Linear Mode
