Multiple chart types on same chart

G

Guest

Hi,

I have following data in columnar format

Quarter of the year (e.g. Q1, Q2, Q3, Q4)

Geographic zone of organization, e.g. (North, East, West, South)

4 Top selling products of the company (P1, P2, P3, P4)

And eventually the sales amounts for the concerned product in the concerned
zone for the concerned quarter.

I would like to have a single chart that displays on the x-axis the Quarters
of the year. For each quarter the geographic zone data is shown as clustered
bars, and the product info per zone is shown as stacked bar.

Thus visually I will have per quarter the 4 geographic zones clustered.
Within each geographic zone I could see the revenues from each of the 4
products.

Can someone help? I know it is doable as I used to do it a few years ago
but cannot relocate a backup of my .xls of those days :-(

Many thanks in anticipation
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
Stacked + Clustered 4
Actual vs Budgeted - Stacked Bar Chart 1
combining chart types 1
How do I combine stacked and clustered chart types? 2
Combination chart 3
Help with 2007 Chart Layout 1
Chart combinations 2

Top