Copy range of cells omitting formulas that result in " "

  • Thread starter Plot only cells with values in column
  • Start date
P

Plot only cells with values in column

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
 
B

bj

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.
 
Top