Use percentages instead of values
 

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?

Use percentages instead of values
 

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" wrote in message
...
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?

Use percentages instead of values
 

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?

Use percentages instead of values
 

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?

Use percentages instead of values
 

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?