+ Reply to Thread
Results 1 to 5 of 5

Plotting a standard bar graph on the same axes as a stacked bar graph

  1. #1
    Registered User
    Join Date
    12-15-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    16

    Plotting a standard bar graph on the same axes as a stacked bar graph

    Hi all,

    I am hoping you can assist me with the following problem.

    I am attempting to produce a graph that includes both a bar chart and a stacked bar chart on the same set of axes.
    I have attached an example spreadsheet with a picture of what I am aiming for.

    Any questions, please do not hesitate to ask.

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,126

    Re: Plotting a standard bar graph on the same axes as a stacked bar graph

    It's all in the data layout

    http://peltiertech.com/WordPress/clu...mn-bar-charts/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-15-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Plotting a standard bar graph on the same axes as a stacked bar graph

    Took quite a bit of moving things around, but got there in the end.

    Thanks for the assistance Andy.

    Is this the only way of achieving this result? I ask for future reference, in case I require this sort of graph for larger databases.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,126

    Re: Plotting a standard bar graph on the same axes as a stacked bar graph

    Yes, there is no builtin cluster/stack option

  5. #5
    Registered User
    Join Date
    12-15-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Plotting a standard bar graph on the same axes as a stacked bar graph

    Ok, thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  2. Stacked Bar Graphs with dual axes and a line graph.
    By kmt1984 in forum Excel General
    Replies: 2
    Last Post: 07-14-2010, 06:56 AM
  3. Plotting two axes on a scatter graph
    By Climaxgp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-06-2010, 07:27 AM
  4. How to create a stacked, staggered column graph w/ 2 y axes
    By uneakbreed in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-15-2007, 04:56 PM
  5. Creating a graph similar to a stacked column graph
    By Jonathan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-04-2006, 11:30 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1