Column Chart With 2 Values I One Line?

[rockyw]

Can I make a column chart that a single line will show 2 values, one with maybe in red, the second with blue? I would like if the total is 10, 4 would show red, the other 6 in blue but still show as a single colunm. Can I do this? Thanks

 

[Robert Mika]

You can try a stack Chart but you ned to first split your data in your case 10 into and 4 and the add as two separate series.

 

[rockyw]

That looks great, do I start with a colunm chart? What type of chart do I start with. I tried entering 2 data cells but I get 2 colunms. Thanks

 

[FryGirl]

Hi Rockyw,

When you insert the chart pick select stacked column.

Here is a page worth reading/book marking.

http://peltiertech.com/Excel/ChartsHowTo/

 

[rockyw]

Thnk you I will read this asap. I am using 2007, I don't even see an option for stacked colunm. Is that in 2007? Thanks

 

[FryGirl]

Yes.

On the Insert tab on the ribbon >> Charts >> Column >> 2-D Column >> Stacked Column

 

[rockyw]

Bingo! Thanks and have a great weekend. Rocky

 

[FryGirl]

Hope you have a great weekend yourself.