Stacked and solid bar graph in one
 

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?

Stacked and solid bar graph in one
 

Hi,

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

Cheers
Andy

tamir32880 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Stacked and solid bar graph in one
 

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" wrote:

Hi,

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

Cheers
Andy

tamir32880 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Stacked and solid bar graph in one
 

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"tamir32880" wrote in message
...
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" wrote:

Hi,

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

Cheers
Andy

tamir32880 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info