Calculate your percentages in the worksheet, then use one of these utilities
to apply the calculations as data labels:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

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


"stacy05" wrote in message
...
Thanks! Is there a way to show the percntages, like in a pie chart?

"LanceB" wrote:

Stacked Column Graph
Set up as

labor
code ACT PLAN
a 1 1
b 3 2
c 5 3
d 9 4

select series in "Rows"

"stacy05" wrote:

HI!! I think I am thinking too much about this and it is easier than it
seems, but I cant figure it out! hopefully someone can help.

So I need to create a chart with 2 column...plan vs. actual. But I need
each
of these bar columns to be separted by percentages of the categories
that
make them up.
EX: I need to make a comparison on how big of a percentage the Labor
part of
the Budget was when they planned and how it differs from the actual
execution.

Thanks for your help!