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 quot;inquot; total and an quot;outquot; total for Nov, Dec and January. I want to
show all quot;insquot; as blue and all quot;outsquot; as red. This would be for a bar chart.
If I put the text quot;inquot; and quot;outquot; 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
quot;Tee Ransonequot; lt;Tee gt; wrote in message
...
gt;I have 2 different data groups in the same month for a 3 month period. I
gt;want
gt; to show the same data groups for all three months in the same color.
gt; Example:
gt;
gt; I have an quot;inquot; total and an quot;outquot; total for Nov, Dec and January. I want
gt; to
gt; show all quot;insquot; as blue and all quot;outsquot; as red. This would be for a bar
gt; 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
quot;Bernard Liengmequot; wrote:
gt; If I put the text quot;inquot; and quot;outquot; in B1 and C1
gt; In A2:A4 I have month names : Nov, Dec and Jan
gt; In B2:B4 I have in values and in C2LC4 I have out vlaues
gt; Seelct A1:C4 and make a bar chart
gt; The Out data is red, the In data blue
gt; Can you follow this?
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Tee Ransonequot; lt;Tee gt; wrote in message
gt; ...
gt; gt;I have 2 different data groups in the same month for a 3 month period. I
gt; gt;want
gt; gt; to show the same data groups for all three months in the same color.
gt; gt; Example:
gt; gt;
gt; gt; I have an quot;inquot; total and an quot;outquot; total for Nov, Dec and January. I want
gt; gt; to
gt; gt; show all quot;insquot; as blue and all quot;outsquot; as red. This would be for a bar
gt; gt; chart.
gt;
gt;
gt;
- Jul 25 Fri 2008 20:45
How can I show different bar colors in the same chart?
close
全站熱搜
留言列表
發表留言
留言列表

