Chart Series With Zero Values - How to ommit from chart

Hi All

Can anyone help with a problem with a chart series.

I have 12 Legend Entries (series) within a line chart. These represent temperature readings, and the data used will always have 12 records. I have used the offset function to calculate the range of data .

My problem is how to ommit the data in a column (series) if that column consist of only zeros....ie there was no temperature recorded or it was not in use.

Any ideas of how to approach the problem would be apprecated..

Kindest regards


Diane

Hi Diane (of the narrow lines),

Try replacing the ZERO VALUES with blanks. According to Andy Pope the Excel Chart Wizard '#N/A' is supposed to work, but BLANKS seem to work better for me. He has many excellent examples that have helped me many times at:http://www.andypope.info/charts/brokenlines.htm

See the attached Excel 2003 workbook containing a line chart created with the Chart Wizard containing several series. Delete the items in Column G one by one, and watch the line disappear.

Lewis

Hi Lewis

Thanks for coming to the rescue again.

It's not quite as simple as that. I have attached a sample data sheet for you to have a look at.

Diane

Test Temperature Chart.xlsx

Hi Diane,

Not so simple requires a not so simple solution.

Click on the Chart in question then run the following Macro. It should delete all Data Series with ALL ZERO values.

Lewis

Please Login or Register  to view this content.

Hi Lewis

Just to let you know the code is just what I needed. It's working like a dream.

Thanks

Diane