I am creating a graph with a lot of series points(+/-15-20), but only a few
have values above 0 in them. This changes as new data is inputted daily. I
want to know if it is possible to create a chart that only plot the series
with values above 0 and ommits the other series from the graph. The graph is
updated daily so if one of the series gets a value of more than 0, then it
has to plot on the graph. I am using a normal column graph and don't want to
convert it to a pie graph if not necessary.

I am using Microsoft Office 2003

On Wed, 28 Nov 2007 05:47:01 -0800, Frikkie
<(E-Mail Removed)> wrote:

Omit the data you don't want from the underlying query:
select ... where YourValueColumn > 0

-Tom.


>I am creating a graph with a lot of series points(+/-15-20), but only a few
>have values above 0 in them. This changes as new data is inputted daily. I
>want to know if it is possible to create a chart that only plot the series
>with values above 0 and ommits the other series from the graph. The graph is
>updated daily so if one of the series gets a value of more than 0, then it
>has to plot on the graph. I am using a normal column graph and don't want to
>convert it to a pie graph if not necessary.
>
>I am using Microsoft Office 2003