Stacked Bar with Reg Bar Chart
 

I am using Excel 2000
I want to create a chart that compares our monthly Sales goal with the sales
by catergory. Ex: $100,000 sales goal (1 bar on the graph) We sell up of 4
different products; prod a, b, c and d. The product sales $$ (ex: A =
25,000; B = 20,000; C = 10,000 and D = 5,000) would be in a stacked bar so as
to see how close we are to our total sales goal. Sold $60,000 compared to
our goal of $100,000. I thought I would need to have 2 axises; one for the
goal and one for the actual sales bars, but I can not figure out how to do
this with a bar graph. Can anyone point me in the right direction? I would
really appreciate any help I can get.

Thank you -- Aurora

Stacked Bar with Reg Bar Chart
 

Hi,

You can be done with by data layout and combination chart.
Jon Peltier has a collection of links to various examples.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Aurora wrote:
I am using Excel 2000
I want to create a chart that compares our monthly Sales goal with the sales
by catergory. Ex: $100,000 sales goal (1 bar on the graph) We sell up of 4
different products; prod a, b, c and d. The product sales $$ (ex: A =
25,000; B = 20,000; C = 10,000 and D = 5,000) would be in a stacked bar so as
to see how close we are to our total sales goal. Sold $60,000 compared to
our goal of $100,000. I thought I would need to have 2 axises; one for the
goal and one for the actual sales bars, but I can not figure out how to do
this with a bar graph. Can anyone point me in the right direction? I would
really appreciate any help I can get.

Thank you -- Aurora

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Stacked Bar with Reg Bar Chart
 

Andy - thank you for responding. I went to Bernard Liengme's site but all I
got was empty boxes with the little red "x" in the corner. Does that mean
that his site is not active any more or is there another reason I can not
bring it up.

Aurora

"Andy Pope" wrote:

Hi,

You can be done with by data layout and combination chart.
Jon Peltier has a collection of links to various examples.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Aurora wrote:
I am using Excel 2000
I want to create a chart that compares our monthly Sales goal with the sales
by catergory. Ex: $100,000 sales goal (1 bar on the graph) We sell up of 4
different products; prod a, b, c and d. The product sales $$ (ex: A =
25,000; B = 20,000; C = 10,000 and D = 5,000) would be in a stacked bar so as
to see how close we are to our total sales goal. Sold $60,000 compared to
our goal of $100,000. I thought I would need to have 2 axises; one for the
goal and one for the actual sales bars, but I can not figure out how to do
this with a bar graph. Can anyone point me in the right direction? I would
really appreciate any help I can get.

Thank you -- Aurora

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info