Chart Series With Zero Values - How to ommit from chart

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