Prev: error bars types
Next: Pivot Chart won't refresh!
From: Roachie on 20 Jan 2010 15:11
Some of my source data contains cells with "0" values that I don't want to
show on my chart. How can I get them to now show up? I need to leave those
cells in my source data range as I am working with a spreadsheet that is
updated monthly so as to automatically update the chart.
--
Karen
From: Bernard Liengme on 21 Jan 2010 08:54
How about a custom format like 0.0;-0.0;""
Right click a data label on chart and select Format Data Labels
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Roachie" <Roachie(a)discussions.microsoft.com> wrote in message
news:B5C9914F-5C7D-4CCD-A193-31E74E43FA04(a)microsoft.com...
> Some of my source data contains cells with "0" values that I don't want to
> show on my chart. How can I get them to now show up? I need to leave
> those
> cells in my source data range as I am working with a spreadsheet that is
> updated monthly so as to automatically update the chart.
> --
> Karen

From: Roachie on 22 Jan 2010 12:08
Thanks Bernard! I was able to get it to work by using the custom format of
0.0;-0.0;

This sight is awesome!
--
Karen


"Bernard Liengme" wrote:

> How about a custom format like 0.0;-0.0;""
> Right click a data label on chart and select Format Data Labels
> best wishes
> --
> Bernard Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
>
> "Roachie" <Roachie(a)discussions.microsoft.com> wrote in message
> news:B5C9914F-5C7D-4CCD-A193-31E74E43FA04(a)microsoft.com...
> > Some of my source data contains cells with "0" values that I don't want to
> > show on my chart. How can I get them to now show up? I need to leave
> > those
> > cells in my source data range as I am working with a spreadsheet that is
> > updated monthly so as to automatically update the chart.
> > --
> > Karen
>
> .
>
From: Bernard Liengme on 23 Jan 2010 10:44
Thanks for the feedback
Bernard

"Roachie" <Roachie(a)discussions.microsoft.com> wrote in message
news:71F587FD-F69E-400F-9EBC-AA470FC5FFE0(a)microsoft.com...
> Thanks Bernard! I was able to get it to work by using the custom format
> of
> 0.0;-0.0;
>
> This sight is awesome!
> --
> Karen
>
>
> "Bernard Liengme" wrote:
>
>> How about a custom format like 0.0;-0.0;""
>> Right click a data label on chart and select Format Data Labels
>> best wishes
>> --
>> Bernard Liengme
>> Microsoft Excel MVP
>> http://people.stfx.ca/bliengme
>>
>> "Roachie" <Roachie(a)discussions.microsoft.com> wrote in message
>> news:B5C9914F-5C7D-4CCD-A193-31E74E43FA04(a)microsoft.com...
>> > Some of my source data contains cells with "0" values that I don't want
>> > to
>> > show on my chart. How can I get them to now show up? I need to leave
>> > those
>> > cells in my source data range as I am working with a spreadsheet that
>> > is
>> > updated monthly so as to automatically update the chart.
>> > --
>> > Karen
>>
>> .
>>
 | 
Pages: 1
Prev: error bars types
Next: Pivot Chart won't refresh!