Prev: How to set the bar with same X-axis value in same colour?
Next: Drawing a line on a chart
From: Patti on 10 Mar 2010 03:19
my line keeps bouncing back to zero instead of showing a gap
From: Bernard Liengme on 10 Mar 2010 10:27
Where there are zeros (or blanks) insert =NA()
This will display as #N/A and will be ignored by the chart engine
Not pretty on your report? Use conditional formatting to hide the N/a
Formula is =ISNA(A1)... format to make cell font colour match cell
background colour
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Patti" <Patti(a)discussions.microsoft.com> wrote in message
news:5E70E21B-26BA-4839-8510-DA4B8056FEA5(a)microsoft.com...
> my line keeps bouncing back to zero instead of showing a gap

From: AdamV on 12 Mar 2010 07:55
As Bernard says, if you can directly manipulate your data, replacing
blanks with #N/A will always deal with this (use GoTo > Special to find
your blank cells)

In many cases though, all you need to do is go to Select Data > click on
the button for "Hidden and empty cells" and choose to show gaps instead
of zeroes.

Hope this helps.
Adam

On 10/03/2010 08:19, Patti wrote:
> my line keeps bouncing back to zero instead of showing a gap
 | 
Pages: 1
Prev: How to set the bar with same X-axis value in same colour?
Next: Drawing a line on a chart