Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Combining stacked colums graphs (97)

    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Combining stacked colums graphs (97)

    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

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Combining stacked colums graphs (97)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •