Thread: 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

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