Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to not show a dash as a zero in Excel chart?
I'm setting up an spreadsheet to pull data and automatically graph a defined
array of cells in a chart. When I have a dash (-) showing up in a cell, it is graphed as a zero. Is there any logic that I can implement so that a dash doesn't show up on the chart. I tried If/then statements where the "-" would be replaced by " " but that still graphed a zero. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
how to change line spacing for text box in excel chart | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel |