ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Help with 2007 Chart Layout (https://www.excelbanter.com/charts-charting-excel/248144-help-2007-chart-layout.html)

Stephanie

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

Herbert Seidenberg

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


All times are GMT +1. The time now is 11:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com