| 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) | |||
Linear Mode
