Combine two different column charts

G

giamma#14

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
 

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

Stacked Bar Graph 1
Stacked Column Charts 2
100% Stacked column with 3D-effect, multiple colums? 1
Two Data Sets: Stacked Column Chart 1
Combine Clustered Column and Stacked Column 1
Needed: Chart that combines clustered column and stacked column types 3
How to: 3 side by side columns with overlayed (?) data 2
Adding a secondary axis in 2007 1

Top