Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Help with 2007 Chart Layout
0 views
Skip to first unread message
Stephanie
Nov 10, 2009, 10:28:29 PM11/10/09
to
Hi,
I can't figure out how to build the chart I'm hoping to create.
I can't figure out how to build the chart I'm hoping to create.
I have data by: quarters, regions, $ and #.
Q1 Americas $100 5
Q2 Americas $200 7
Q3 Americas $120 3
Q1 Asia $213 4
Q2 Asia $312 2
...
Q1 Europe ...
Q2 Eroupe...
...
I'd like to have on the X-axis: region, on the y-axis $ (columns) and a
secondary axis # (line graph). What's throwing me is the quarters.
X axis: America with 3 bar graphs side by side for Q1, Q2, Q3 then a new
grouping of bar graphs side by side for Asia Q1, Q2, Q3.
Can this be accomplished? I'd appreciate any charting suggestions- still
trying to get the hang of 2007.
Let's for taking the time!
Stephanie
Herbert Seidenberg
Nov 13, 2009, 12:26:09 PM11/13/09
to
0 new messages