If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
Show both value and percentage on Waterfall Chart | Tim | Charts and Charting | 2 | September 29th, 2005 04:57 PM |
Change chart colors at report run time | rogge | Setting Up & Running Reports | 1 | March 31st, 2005 01:37 PM |
how to show organization chart contents one by one | Tenson Yeung | Powerpoint | 1 | November 1st, 2004 12:59 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |