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
|
|||
|
|||
Help with 2007 Chart Layout
Hi,
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 |
#2
|
|||
|
|||
Help with 2007 Chart Layout
|
Thread Tools | |
Display Modes | |
|
|