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
|
|||
|
|||
How lines in combination charts treat #N/A values
In an all-line chart, #N/A valies are not shown ... highly useful for showing
an incomplete line. However, in a combination chart (third data type is a line, displaying to the secondary axis) this does not happen, and #N/A values are being treated as zeros. Any ideas on what I can do to make the line truncate??? Thanks in anticipation! -- Bernard |
#2
|
|||
|
|||
How lines in combination charts treat #N/A values
In my combo chart, the line on the secondary axis treated #N/A as expected,
by interpolating across the missing value. Make sure what looks like "#N/A" is really the NA error, and not a bit of text that mimics the error. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Bernard Harris" bernard@Reading_UK wrote in message ... In an all-line chart, #N/A valies are not shown ... highly useful for showing an incomplete line. However, in a combination chart (third data type is a line, displaying to the secondary axis) this does not happen, and #N/A values are being treated as zeros. Any ideas on what I can do to make the line truncate??? Thanks in anticipation! -- Bernard |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Charts with negative values | Art | Powerpoint | 5 | January 12th, 2006 05:59 PM |
hiding zero values in charts | fascal | Charts and Charting | 4 | December 19th, 2005 02:17 PM |
Excel Chart Vertical Lines Corrupting? | Ken Black | Charts and Charting | 4 | June 4th, 2004 09:16 PM |
Lines in graph only if values in fields | Jon Peltier | Charts and Charting | 0 | December 5th, 2003 05:24 PM |
Lines in graph only if values in fields | Vads | Charts and Charting | 0 | December 5th, 2003 03:21 PM |