Blank cells in named range- how to ignore them when making my graph? Help plz!

K

KR

I have a series of named ranges; the referenced cells have formulas that
pull from various other worksheets. Some of the cells return blank ("" or 0
or na(), depending on how I set up the formulas). I need to create a stacked
column chart showing _only_ the data that is returned, ignoring the
blanks/zeros. For example:

Animal # <2yrs
-------- -- -------
Cats 122 34
Dogs 212 86
<blank> <blank> <blank>
Fish 54 50
<blank> <blank> <blank>
Ferrets 6 3

I'll just use offset (I think, depending on the answer to this post) to get
the subsequent columns as named ranges to populate the graph, but I can't
figure out how to get my named range to return the following so I can graph
it, without having the extra X-axis spaces on my graph for the blank rows:

Cats
Dogs
Fish
Ferrets

Any advice/suggestions/solutions greatly appreciated,
Keith
 

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

repost: plz help- dynamic range with gaps? 2
if there is a blank ,how to get the blank cell in a range be highlighted 2
need help in fine-tuning a formula that removes blank cells in a column range 3
Help! Need to ignore 0s and blank cells in average formula! 2
using indirect to return a named range? 1
Macro to loop through a named range, ignoring empty cells 1
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL 2
How to ignore blank date cells in sumproduct 5

Top