View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
LanceB LanceB is offline
external usenet poster
 
Posts: 8
Default Percentage Column Charts

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!