View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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?