Stacked Bar with Reg Bar Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 - 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
 
Back
Top