Results 1 to 4 of 4

Thread: Clustered Column Bar Graph - Change Groups/Pairs

  1. #1

    Clustered Column Bar Graph - Change Groups/Pairs



    Register for a FREE account, and/
    or Log in to avoid these ads!

    In the attached graph, I would like to change the groupings or pairs. Currently, 2014 is one group and 2015 another group. I would like to try it with four groups - ID, MH, SA, and NC. It would look the same, but ID 2014 and ID 2015 would be a pair with the same color. The next pair would be MH 2014 and MH 2015. Then the same with the next two. Each pair would have a different color. I know I'm missing something simple. Thanks for any assistance or helpful links.
    2014 2015
    ID 19 21
    MH 283 323
    SA 63 84
    NC 113 110
    Attached Files Attached Files

  2. #2
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    102
    Articles
    0
    Excel Version
    365
    Hi,

    Just click on the button SWITCH ROW/COLUMN in the graph rubbon

    Good luck

  3. #3
    Thanks, hossat. The way you suggested is a valid way to present the data, but I needed the graph in a different format. Someone suggested staggering the data. That works for my purposes. I attached a sample of what I decided to use.
    Attached Files Attached Files

  4. #4
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    102
    Articles
    0
    Excel Version
    365
    You're welcome

Posting Permissions

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