View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Keith Keith is offline
external usenet poster
 
Posts: 262
Default 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?