Prev: Axis labeling
Next: copying chart to location within same workbook
From: Stephanie on 10 Nov 2009 22:28
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
From: Herbert Seidenberg on 13 Nov 2009 12:26
Excel 2007 PivotChart
Format Quarters.
http://www.mediafire.com/file/2ytztedvmxn/11_13_09.xlsm
 | 
Pages: 1
Prev: Axis labeling
Next: copying chart to location within same workbook