Stacked Chart, But not that simple!

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Stacked Chart, But not that simple!

  1. #1
    New Member
    Join Date
    May 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Stacked Chart, But not that simple!

     
    Hi Everyone,

    I would like to make a stacked bar chart, but I need there to be 2 sets of bars for each date. It will be a monthly chart and each month there will be 2 bars, one stacked chart for team 1 and one stacked chart for team 2 (the stack will show different score ranges). This is simple by just adding in the data 2 sets for each date, but what I find to be tricky is how to get the bars right next to eachther for each date, but separate between dates. So it would be like 2 bars together, then space, then 2 bars together, then space, etc

    Any one with experience in this?

    Thanks,

    MH

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    30,518
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Stacked Chart, But not that simple!

      
    Welcome to the forum.

    See for example, Jon Peltier's article here: Clustered and Stacked Column and Bar Charts - Peltier Tech Blog
    or Andy Pope's here: Stacked cluster

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com