Graph troubles

[Chris]

Hello,

I am trying to make a graph that would show the sales for
the US and overlapping would be sales by area. I have a
presentation to do for the area managers and would like to
show the how they relate to the entire US. I am using
excel 2000 and my data looks like this:
July......Jan 04 Projected
Total US (A2)July
Area A(A3)
Area B (A4)

Can anyone help me?
Thanks,
Chris

 

[Peter Atherton]

Chris

Areas Sales % Sales
Area 1 23456 0.3
Area 2 45321 0.6
Area 3 3243 0
Total 72020

Try a Line, Column on 2 Axis chart and calculate the
percentage of each area sales of the total.

Regards
Peter