Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart Property Confusion | Charts and Charting in Excel | |||
How can I get the zero values at the end of a chart not to show? | Charts and Charting in Excel | |||
Show goal in chart | Excel Discussion (Misc queries) | |||
Fan charts | Charts and Charting in Excel | |||
How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel |