Excel 97 - Chart Line - Gap for zero values

  • Thread starter Thread starter Michael Goodwin
  • Start date Start date
M

Michael Goodwin

Hi,

Instead of a line returning to zero on the Y axis, I want it to simply
'dissapear' (and resume) whenever it next represents a non-zero value. Any
ideas?

Examples,
1. Show a full year chart Jan - Dec but only show the line for the ytd to
August and NOT drop down to zero for Sept, Oct . . . .

2. Show all last years data but also leave a gap in August when no values
were collected and avoid dropping from July to zero (August) and then rising
again to September

Anym help appreciated

Michael
 
Back
Top