Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combine two different column charts
Hi,
I would like to combine two different column charts, the clustered column that compare values across categories and the stacked column that compare contribution of each value to a total. Immagine I have the following data: Service Sector Spain year 2007: 100 - year 2008: 120 All sectors Spain year 2007: 450 - year 2008: 460 Service Sector Italy year 2007: 150 - year 2008: 150 All sectors Italy year 2007: 500 - year 2008: 505 I would like a graph that shows me for each country two columns, one for 2007 and one for 2008. However, I also want to see in each column how big the service sector is. Thanks a lot in advance |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combine two different column charts
Here's a brief tutorial:
http://peltiertech.com/WordPress/200...column-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "giamma#14" wrote in message ... Hi, I would like to combine two different column charts, the clustered column that compare values across categories and the stacked column that compare contribution of each value to a total. Immagine I have the following data: Service Sector Spain year 2007: 100 - year 2008: 120 All sectors Spain year 2007: 450 - year 2008: 460 Service Sector Italy year 2007: 150 - year 2008: 150 All sectors Italy year 2007: 500 - year 2008: 505 I would like a graph that shows me for each country two columns, one for 2007 and one for 2008. However, I also want to see in each column how big the service sector is. Thanks a lot in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine Column & line charts | Charts and Charting in Excel | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
need to combine two charts | Charts and Charting in Excel | |||
Combine Charts | Charts and Charting in Excel | |||
How do I combine two different charts? | Charts and Charting in Excel |