how do I keep from plotting zero values in graphs

  • Thread starter Thread starter Frikkie
  • Start date Start date
F

Frikkie

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

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

-Tom.
 
Back
Top