Help with 2007 Chart Layout

[Stephanie]

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

 

[Herbert Seidenberg]

Excel 2007 PivotChart
Format Quarters.
http://www.mediafire.com/file/2ytztedvmxn/11_13_09.xlsm