Combining stacked colums graphs (97)

Topic

New Reply

Hey,
I think I’ve reached the limits of Excel’s graphing capabilities, but… maybe someone of you can help me out of this…
I have a stacked column graph presenting data from one year. Now I want to compare data from different years and would like to do that in one graph. Is this possible? E.g. by merging multiple graphs in some way (or even better: putting one on the background, a little pale), or by creating a 3D presentation of stacked column graphs?
I know that such multiple variable graphs might get quite ‘crowded’ but nevertheless I would like to give it a try…
In attachment you find a simple example of the graph I would like to combine two ‘years’ of into one…
Thanks for any feedback!
Hasse

Reply | Quote

Replies

How about something like this? I modified the pivot to get the data in one table (you could use multiple pivots)

Excel doesn’t do 3-d stacked. This has the country and the years for the country together.

Steve

Reply | Quote

Hey, Steve,
thanks a lot – that will do!
Hasse

Reply | Quote

How about something like this? I modified the pivot to get the data in one table (you could use multiple pivots)

Excel doesn’t do 3-d stacked. This has the country and the years for the country together.

Steve

Reply | Quote