Ignoring 0 values in the series data
 

How can I get my chart to ignore values which are zero in the series data and
not show these?

replace zeros with =NA()

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=380038

You can delete the formulas that are producing zero, or replace them with
=IF(formula=0,#N/A,formula)

Jerry

Alison wrote:

How can I get my chart to ignore values which are zero in the series data and
not show these?

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?!

"Alison" wrote:

How can I get my chart to ignore values which are zero in the series data and
not show these?

I think you will have to set up cells that summarize only the customers
worked on, and plot that summary information.

Jerry

Alison wrote:

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?!

"Alison" wrote:


How can I get my chart to ignore values which are zero in the series data and
not show these?

here yah go

http://www.andypope.info/charts/brokenlines.htm

"Jerry W. Lewis" wrote:

I think you will have to set up cells that summarize only the customers
worked on, and plot that summary information.

Jerry

Alison wrote:

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?!

"Alison" wrote:


How can I get my chart to ignore values which are zero in the series data and
not show these?