Prev: Why do my charts not opening correctly ?
Next: Conditional Formatting - Apply to Charts?
From: Keith on 1 Jul 2008 10:48
I have a series of numbers that show how a hard drives space is being used.
The table shows the figures in GB values. How do I get a pie chart based on
the table to show the % per section and not the GB value?
From: Jon Peltier on 1 Jul 2008 15:21
In the data labels tab of the format series or chart options dialogs, you
can select percentage instead of value for display in the labels of a pie
chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Keith" <Keith(a)discussions.microsoft.com> wrote in message
news:06588F06-8C97-46D0-9A1D-899B1BC1A8F6(a)microsoft.com...
>I have a series of numbers that show how a hard drives space is being used.
> The table shows the figures in GB values. How do I get a pie chart based
> on
> the table to show the % per section and not the GB value?


From: ShaneDevenshire on 1 Jul 2008 15:22
Hi,

With the chart selected, choose, Chart, Chart Options, Data Labels tab and
turn on Percent and turn off Values.

Same idea in 2007 but an entirely differnent place.
--
Cheers,
Shane Devenshire


"Keith" wrote:

> I have a series of numbers that show how a hard drives space is being used.
> The table shows the figures in GB values. How do I get a pie chart based on
> the table to show the % per section and not the GB value?
From: Keith on 2 Jul 2008 04:12
Thanks for that. I was half way there. I just hadn't switched off the values.

"ShaneDevenshire" wrote:

> Hi,
>
> With the chart selected, choose, Chart, Chart Options, Data Labels tab and
> turn on Percent and turn off Values.
>
> Same idea in 2007 but an entirely differnent place.
> --
> Cheers,
> Shane Devenshire
>
>
> "Keith" wrote:
>
> > I have a series of numbers that show how a hard drives space is being used.
> > The table shows the figures in GB values. How do I get a pie chart based on
> > the table to show the % per section and not the GB value?
From: ShaneDevenshire on 2 Jul 2008 22:23
Hi Keith,

It the response(s) are useful you should click the appropriate Yes buttons
to the right of the question to record the correct status.
--
Thanks,
Shane Devenshire


"Keith" wrote:

> Thanks for that. I was half way there. I just hadn't switched off the values.
>
> "ShaneDevenshire" wrote:
>
> > Hi,
> >
> > With the chart selected, choose, Chart, Chart Options, Data Labels tab and
> > turn on Percent and turn off Values.
> >
> > Same idea in 2007 but an entirely differnent place.
> > --
> > Cheers,
> > Shane Devenshire
> >
> >
> > "Keith" wrote:
> >
> > > I have a series of numbers that show how a hard drives space is being used.
> > > The table shows the figures in GB values. How do I get a pie chart based on
> > > the table to show the % per section and not the GB value?
 | 
Pages: 1
Prev: Why do my charts not opening correctly ?
Next: Conditional Formatting - Apply to Charts?