Results 1 to 2 of 2

Stacked Chart, But not that simple!

This is a discussion on Stacked Chart, But not that simple! within the Excel Questions forums, part of the Question Forums category; Hi Everyone, I would like to make a stacked bar chart, but I need there to be 2 sets of ...

  1. #1
    New Member
    Join Date
    May 2016
    Posts
    1

    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
    29,784

    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

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