Copy range of cells omitting formulas that result in " "

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

graphing data only in a certain range 2
set cell to empty 1
Can blank cells be omitted from graph? 7
Blank Values in Excel Charts 7
Formula omits adjacent cells 2
How do I make a rank equation that omits particular cells? 1
Chart display of no value cells 1
Don't want to plot blank cells on my chart 4

Back
Top