+ Reply to Thread
Results 1 to 3 of 3

Combining Stacked Bar Graph with Scatter Graph

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    2

    Combining Stacked Bar Graph with Scatter Graph

    I'm trying to build a timeline graph showing certain "stage gate" dates for each project.

    Each project has a start and end date (and obviously duration) which is depicted by the stacked bar chart. I can set this part up..

    The problem i then have is trying to depict the stage gates for each of the projects. Ideally along project there will just be a marker for each stage gate.. At the moment i've tried converting the stage gate data series (scope, evaluate, design, build) to scatter plots but it seems to plot it on the secondary axis.. which obviously means that it doesn't line up with my stacked bar, and ultimately doesn't look pretty.

    Been going around in circles for a while and just can't seem to set it up.

    Any help is greatly appreciated!

    PM Graph mock.xlsx

  2. #2
    Registered User
    Join Date
    03-20-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Combining Stacked Bar Graph with Scatter Graph

    bumpity bump

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

    Re: Combining Stacked Bar Graph with Scatter Graph

    You need to use xy-scatter lines rather than Line chart lines.

    Start by making all the series stacked bars.
    Move the line series to secondary axis and then change to xy-scatter.
    change range references for xy-scatter series.
    add secondary vertical axis and format min/max
    format both horizontal axes min/max/major
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Combining a bar graph and line graph with 2 sets of data
    By lynzlou in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-11-2014, 12:49 AM
  2. [SOLVED] Plotting a standard bar graph on the same axes as a stacked bar graph
    By Shearwater in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2014, 04:59 AM
  3. [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
  4. 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
  5. Can I create graph combining clusted and stacked columns?
    By Robin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-19-2006, 11:35 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