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

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

Guest

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.
 
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:

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