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 |