Percentage Column Charts

[Guest]

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!

 

[Guest]

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"

 

[Guest]

Thanks! Is there a way to show the percntages, like in a pie chart?

 

[Jon Peltier]

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