View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
giamma#14 giamma#14 is offline
external usenet poster
 
Posts: 1
Default 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