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 |
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 |
All times are GMT +1. The time now is 01:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com