Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple chart types on same chart
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple chart types on same chart
Sounds like this might help:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "DKS" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
multiple chart types on pivot | Charts and Charting in Excel | |||
Mix chart types | Excel Discussion (Misc queries) | |||
chart types | Excel Worksheet Functions | |||
Create a combo chart with two of the same chart types | Charts and Charting in Excel |