Excel Spreedsheet Graph Help!!!

^Mike^

Fully Optimized
Messages
2,958
My dad asked me to do a bar graph for his company and it is planned to look something like this:
http://www.originlab.com/www/products/GraphGallery.aspx?GID=44&s=8&lm=215
you see how some bars are just blue and others are a combination of blue, green , and red. The way he wants it is just a 2 color bar instead of 3 colored.

I don't know how to do the 2 color bars? Can anyone help me with setting it up?
On the bottom of the graph is "Years" 2001-2007, on the side is "Dollars in Millions" and it must go up to 30.
 
When you make the chart, press column, then under the column subtypes select the 3-color stacked one.

Edit: Also, I think the data has to be under seperate columns when you select it for excel to recognize it.
If you need me to make it for you I can.
 
Yeah, Like this?
untitled2.JPG
 
Back
Top Bottom