Stacked and solid bar graph in one

[tamir32880]

I need to make a graph that for each month, includes a solid bar (for
budgeted data) and a stacked bar (for 2 categories that make up actual data).
For the life of me I can't figure it out. Can anyone tell me if this is
possible, if so how to create it?

 

[Andy Pope]

Hi,

You will find information on create that type of chart here,
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[tamir32880]

Thank you Andy, that worked, now I just have a formatting question - how can
I make the bars centered in between the tick marks for each month on the
graph?

 

[Andy Pope]

Hi,

Not sure exactly what you mean. They should be centered.

Cheers
Andy