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.

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 Ransone@discussions.microsoft.com> wrote in message
news:830EA1B5-83C3-4DD2-8006-F4DC514ED572@microsoft.com...
>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.

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 Ransone@discussions.microsoft.com> wrote in message
> news:830EA1B5-83C3-4DD2-8006-F4DC514ED572@microsoft.com...
> >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.
>
>
>