+ Reply to Thread
Results 1 to 7 of 7

How to add a vertical line graph on a stacked horizontal bar chart?

Hybrid View

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

    Re: How to add a vertical line graph on a stacked horizontal bar chart?

    Add a new series
    change to xy-scatter
    set the data ranges for the x and y values
    set the maximum value for the secondary vertical axis in order to align data points
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  2. #2
    Registered User
    Join Date
    06-20-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to add a vertical line graph on a stacked horizontal bar chart?

    Quote Originally Posted by Andy Pope View Post
    Add a new series
    change to xy-scatter
    set the data ranges for the x and y values
    set the maximum value for the secondary vertical axis in order to align data points
    Sorry to open up an old thread but I need to do exactly what you're talking about. My problem is that I don't know how to set the data ranges for X and Y values or set the maximum value for the secondary vertical axis in order to align data points. Can you give me some more detailed instruction?

    thanks.

+ 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. Stacked waterfall chart with horizontal line
    By kalam1989 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-28-2013, 12:42 PM
  2. [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
  3. [SOLVED] Display vertical line on stacked line chart already using primary and secondary axises
    By ben_hensel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2012, 10:21 AM
  4. Manually add fixed vertical horizontal line to chart
    By datacruncher in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-21-2009, 08:33 AM
  5. [SOLVED] How do i add a line graph onto a stacked column chart using data
    By Nicola in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2005, 11:05 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