Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
"Space" shows up as zero in graphs. What doesnt show up as zero?
I am creating charts that include the full year. Some of the months are in
the future and should be blank. I am referencing a cell that references the data from another cell, so it shows up as zero in the chart rather than discontinuing the line. What value can I put in the false condition of an @if function so that the line just ends and does not continue to zero? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
"Space" shows up as zero in graphs. What doesnt show up as zero?
Put NA() in the formula. This gives you #N/A in the cell, which looks ugly,
but can be hidden using conditional formatting. #N/A is not plotted in a line or XY chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "jdwj" wrote in message ... I am creating charts that include the full year. Some of the months are in the future and should be blank. I am referencing a cell that references the data from another cell, so it shows up as zero in the chart rather than discontinuing the line. What value can I put in the false condition of an @if function so that the line just ends and does not continue to zero? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
"Space" shows up as zero in graphs. What doesnt show up as ze
Thanks Jon. Exactly what I needed.
"Jon Peltier" wrote: Put NA() in the formula. This gives you #N/A in the cell, which looks ugly, but can be hidden using conditional formatting. #N/A is not plotted in a line or XY chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "jdwj" wrote in message ... I am creating charts that include the full year. Some of the months are in the future and should be blank. I am referencing a cell that references the data from another cell, so it shows up as zero in the chart rather than discontinuing the line. What value can I put in the false condition of an @if function so that the line just ends and does not continue to zero? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
"Show Placeholder" feature in options/view doesnt work | Excel Discussion (Misc queries) |