Ignore Blank cells

[Derek Munday]

I have a data series of fixed cells for product categories
(eg. a,b,c,d,e,f) which will not always have values
relating to them, but are required to retrieve data from
different customers.

Is it possible to get a chart to ignore the data series if
the value cells are blank.

This will hopefully allow for data retrieval from multiple
customers, but charts will be created with only relevant
data.

Thanks in advance

Derek

 

[crispbd]

You might try sorting the chart data before creating a chart, sortin
first on the cell(s) that may be empty, then by your primary key

 

[Jon Peltier]

Or use an autofilter to hide rows with zero values in that column.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______