Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there a way to hide zeros in a line graph
I'm creating a line graph which shows zeros. I do not want to show them
|
#2
|
|||
|
|||
Replace zeros by =NA()
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "L Young" <L wrote in message ... I'm creating a line graph which shows zeros. I do not want to show them |
#3
|
|||
|
|||
Bernard,
Thanks for helping. The problem is the cell is a link and I don't think I can manipulate the cell b/c of link. Any other way to include answers in graph greater than '0'. Linda "Bernard Liengme" wrote: Replace zeros by =NA() -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "L Young" <L wrote in message ... I'm creating a line graph which shows zeros. I do not want to show them |
#4
|
|||
|
|||
If the cells are blank, use Tools|Options and open the chart tab and specify
what to do with blanks cells. What is the formula for the link? (You may want to email me directly) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "L Young" wrote in message ... Bernard, Thanks for helping. The problem is the cell is a link and I don't think I can manipulate the cell b/c of link. Any other way to include answers in graph greater than '0'. Linda "Bernard Liengme" wrote: Replace zeros by =NA() -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "L Young" <L wrote in message ... I'm creating a line graph which shows zeros. I do not want to show them |
#5
|
|||
|
|||
If the cell is linked, there must be a formula. So replace this:
=A1 with this: =IF(A1<0,A1,NA()) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ L Young wrote: Bernard, Thanks for helping. The problem is the cell is a link and I don't think I can manipulate the cell b/c of link. Any other way to include answers in graph greater than '0'. Linda "Bernard Liengme" wrote: Replace zeros by =NA() -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "L Young" <L wrote in message ... I'm creating a line graph which shows zeros. I do not want to show them |
#6
|
|||
|
|||
But I dont want #NA in my sheet.
-- Jakob "Jon Peltier" skrev i melding ... If the cell is linked, there must be a formula. So replace this: =A1 with this: =IF(A1<0,A1,NA()) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ L Young wrote: Bernard, Thanks for helping. The problem is the cell is a link and I don't think I can manipulate the cell b/c of link. Any other way to include answers in graph greater than '0'. Linda "Bernard Liengme" wrote: Replace zeros by =NA() -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "L Young" <L wrote in message ... I'm creating a line graph which shows zeros. I do not want to show them |
#7
|
|||
|
|||
Jakob -
Use conditional formatting to hide it: http://contextures.com/xlCondFormat03.html#Errors Or break down and create two ranges, one for display of the data, the other for the chart's source data. If you link them to the original data, they should agree. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jakob Austgulen wrote: But I dont want #NA in my sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
IF formulas creates zeros in a line graph | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with graph ranges | Charts and Charting in Excel |