Zero value and bar graph

P

pgarcia

Hello all,
I'm new to graphs and what I have is a date range (1-Jan-08 - 31-Jan-08)
with a dollor amount in the next cell. The bar graph is picking up the "zero"
or blank ("")cells and is ploting them on the graph. How can I have the graph
not plot the "zero" or blank ("") values?
I did the flowing to the amounts:=IF(N18=0,NA(),N18)
and that remove the "$0" from the graph, but it's still pickup the dates.

Off2000

Thanks
 
A

Andy Pope

Hi,

The NA() trick only suppressed the point/bar/column.
It does not remove the point from the series.

To do that you can hide the row using autofilter and as long as the
chart is set to Plot only visible cells the point should be removed.

If the chart object is in the same rows as the data you will need to
unset the Move and size properties of the chartobject otherwise it will
change size.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Bar Graph Axis Values 0
Hide Cells with Zero Value in Excel 2007 while using line chart ty 4
Suppres Zero or empty Cell value in a line graph 1
Combination Line and Bar Graph 1
How to hide zero values in graphs using Mircosoft excel 2003? 1
Blank cells in graph 8
Hiding Data Points in a chart 1
Charting a variable range 2

Top