G
Guest
How can I get my chart to ignore values which are zero in the series data and
not show these?
not show these?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mangesh_yadav
replace zeros with =NA()
Manges
Manges
J
Jerry W. Lewis
You can delete the formulas that are producing zero, or replace them with
=IF(formula=0,#N/A,formula)
Jerry
=IF(formula=0,#N/A,formula)
Jerry
G
Guest
What you have told me works but I would also like the chart to ignore the
chart label that the zero relates to. I have a spreadsheet that shows how
much time has been spent on differnet customer sites. Using data validation
and a look up table I have set it up so that you can select a partner and
view which customers it has worked on. The problem is the x axis shows all
the customers for FY05, meaning the graph is quite large with lots of empty
spaces. When you select the partner you want to view I would like the graph
to ignore all the customers with 0 and only show the actve ones. Is this
possible?!
chart label that the zero relates to. I have a spreadsheet that shows how
much time has been spent on differnet customer sites. Using data validation
and a look up table I have set it up so that you can select a partner and
view which customers it has worked on. The problem is the x axis shows all
the customers for FY05, meaning the graph is quite large with lots of empty
spaces. When you select the partner you want to view I would like the graph
to ignore all the customers with 0 and only show the actve ones. Is this
possible?!
J
Jerry W. Lewis
I think you will have to set up cells that summarize only the customers
worked on, and plot that summary information.
Jerry
worked on, and plot that summary information.
Jerry
G