| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
chart displaying horizontal line for zero data
Hello,
I am using a column chart in Excel. The chart is currently displaying a horizontal line when there are zeros for the data. It is working as it was designed to do... however I would like to make the graph not display a line when there is all zero data. Is there an easy way to fix this problem? Thanks Pseud |
|
#2
|
|||
|
|||
|
In place of zeros use =NA() This displays as #N/A and these points are
ignored by chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message oups.com... Hello, I am using a column chart in Excel. The chart is currently displaying a horizontal line when there are zeros for the data. It is working as it was designed to do... however I would like to make the graph not display a line when there is all zero data. Is there an easy way to fix this problem? Thanks Pseud |
|
#3
|
|||
|
|||
|
Hi Bernard,
I tried this command =IF(E5 = 0, NA(), NA()) and the cell still displays 0 when 0 is inputed into the cell. Do you have any other suggestions? Thanks, Pseud |
|
#4
|
|||
|
|||
|
Never mind.... i was creating a circular reference.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
