Select all of the data and plot it. then by using auto filter on your data
and selecting non blanks. the chart will not show zeros when plotting.


"Plot only cells with values in column" wrote:

I have a column of data that contains a formula that either returns a value
or leaves the cell blank. I would like to copy the column to another
location and have the cells with no values omitted from the range.
Basically, I would like to make a bar chart and have the chart adjust with
changes in data. However, every empty cell is plotted as zero or blank...how
can I remove these blanks from the chart?
Can anyone help? I have been struggling with this for a while now...I think
this is my last resort!
Help!

Tina