Results 1 to 2 of 2
Like Tree1Likes
  • 1 Post By pgc01

Stacked graph next to a column graph

This is a discussion on Stacked graph next to a column graph within the Excel Questions forums, part of the Question Forums category; Hi all, I have four rows of data (and 3 columns, indicating 2013-2015 yearly data). The first three rows I ...

  1. #1
    Board Regular
    Join Date
    Oct 2006
    Posts
    282

    Default Stacked graph next to a column graph

    Hi all,

    I have four rows of data (and 3 columns, indicating 2013-2015 yearly data). The first three rows I would like to have a stacked graph, showing the contributions of each data point towards the total of the 3. The 4th row I would like to have as its own column graph, next to the stacked graph of the first three rows.

    I've played around with secondary axes, but just cant seem to get it right. Anybody have any tips?

    Thanks!

  2. #2
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    18,761

    Default Re: Stacked graph next to a column graph

    Hi

    Jon Peltier has an article about this type of chart here:

    Clustered and Stacked Column and Bar Charts - Peltier Tech Blog
    Jon Peltier likes this.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

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