Hello,
I have the following data that I would like in a stacked bar graph but
with stacked bars for each year. I am unable to figure a way to do this
and hoping that someone would be kind enough to let me know if it can be
done and give any hints on how please?
1994 1995
0-50cm50-100cm 0-50cmm 50-100cm
214 5 10
122 10 4
72 14 8
3220 16 12
610 13 8
If I do this using graph wizard I get all the data for one year on one
bar--
ndavies
------------------------------------------------------------------------
ndavies's Profile: www.excelforum.com/member.php...foamp;userid=8746
View this thread: www.excelforum.com/showthread...hreadid=512955see www.stfx.ca/people/bliengme/E...ps/Columns.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
quot;ndaviesquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I have the following data that I would like in a stacked bar graph but
gt; with stacked bars for each year. I am unable to figure a way to do this
gt; and hoping that someone would be kind enough to let me know if it can be
gt; done and give any hints on how please?
gt;
gt; 1994 1995
gt; 0-50cm 50-100cm 0-50cmm 50-100cm
gt; 2 14 5 10
gt; 12 2 10 4
gt; 7 2 14 8
gt; 32 20 16 12
gt; 6 10 13 8
gt;
gt; If I do this using graph wizard I get all the data for one year on one
gt; bar
gt;
gt;
gt; --
gt; ndavies
gt; ------------------------------------------------------------------------
gt; ndavies's Profile:
gt; www.excelforum.com/member.php...foamp;userid=8746
gt; View this thread: www.excelforum.com/showthread...hreadid=512955
gt;
- Aug 28 Tue 2007 20:39
How can I display two seperate stacked bars in a graph
close
全站熱搜
留言列表
發表留言