| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero Values on Charts | Charts and Charting in Excel | |||
| Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
| On a combination chart how do i get 2 lines and 1 column? | Charts and Charting in Excel | |||
| How to force continuous lines in line charts | Charts and Charting in Excel | |||
| Problem drawing lines on charts | Charts and Charting in Excel | |||
Linear Mode
