Ignore Blank cells

  • Thread starter Thread starter Derek Munday
  • Start date Start date
D

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
 
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
 
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/
_______
 
Back
Top