Thread: Graph Question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brendan Brendan is offline
external usenet poster
 
Posts: 23
Default Graph Question

Got it. Great, thanks.
Brendan

"Jon Peltier" wrote:

Only a pie chart can show percentages when only the regular values are used
to create the chart.

Calculate the percentages in the worksheet, plot these, and your data labels
will show percentages when you use the 'show value' option.

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


"Brendan" wrote in message
...
Hi

I am using Excel 2000. I have created a 100% stacked column graph. I want
to
display the percentages on the face of the columns themselves. When I
format
the data series and go to data labels the show percent is greyed out.
Probably because % is already shown on the Y axis. However, I also want
them
to be shown on the columns themselves.

Can anybody help?

Thanks
Brendan