Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cluster / Stack Charts (2000)

    Is there any way of creating a cluster chart in which each bar is a stack bar??
    I need to compare 4 aspects of 3 companies over several years. With the years along the x-axis, I would have three bars "clustered" over each year - one for each company. Each bar will be a "stack" of the 4 aspects.
    I have tried to no avail thus far - can anyone help? (Or at least tell me to give up trying!)

  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: Cluster / Stack Charts (2000)

    Something like this??
    Here is a simple example .
    I made up some data, 4 aspects for 3 companies and 3 years (= 36 values)
    I extracted the data in a form that makes a chart better using vlookup and MATCH
    I created a stacked bar chart
    3 years, within each year is a separate bar for each company. within wach company is a stacked bar of the aspects

    Steve

  3. #3
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cluster / Stack Charts (2000)

    That's it! I knew it must be possible - I just had to lay the table out correctly. Seems so simple now I've seen it!
    Thanks for your help.
    Take it easy,
    Al.

Posting Permissions

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