How can I show different bar colors in the same chart?
 

I have 2 different data groups in the same month for a 3 month period. I want
to show the same data groups for all three months in the same color. Example:

I have an "in" total and an "out" total for Nov, Dec and January. I want to
show all "ins" as blue and all "outs" as red. This would be for a bar chart.

How can I show different bar colors in the same chart?
 

If I put the text "in" and "out" in B1 and C1
In A2:A4 I have month names : Nov, Dec and Jan
In B2:B4 I have in values and in C2LC4 I have out vlaues
Seelct A1:C4 and make a bar chart
The Out data is red, the In data blue
Can you follow this?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tee Ransone" <Tee wrote in message
...
I have 2 different data groups in the same month for a 3 month period. I
want
to show the same data groups for all three months in the same color.
Example:

I have an "in" total and an "out" total for Nov, Dec and January. I want
to
show all "ins" as blue and all "outs" as red. This would be for a bar
chart.

How can I show different bar colors in the same chart?
 

Bernard:

You are a gentleman and a scholar! I am a concept girl...not into details
and it always helps to have a different point of view.

Many, many thanks!

Tee Ransone

"Bernard Liengme" wrote:

If I put the text "in" and "out" in B1 and C1
In A2:A4 I have month names : Nov, Dec and Jan
In B2:B4 I have in values and in C2LC4 I have out vlaues
Seelct A1:C4 and make a bar chart
The Out data is red, the In data blue
Can you follow this?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tee Ransone" <Tee wrote in message
...
I have 2 different data groups in the same month for a 3 month period. I
want
to show the same data groups for all three months in the same color.
Example:

I have an "in" total and an "out" total for Nov, Dec and January. I want
to
show all "ins" as blue and all "outs" as red. This would be for a bar
chart.