Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentages | Excel Discussion (Misc queries) | |||
percentages | New Users to Excel | |||
Percentages | Excel Worksheet Functions | |||
Percentages | Excel Worksheet Functions | |||
percentages | Excel Discussion (Misc queries) |