+ Reply to Thread
Results 1 to 9 of 9

Show delta value between two line graphs

  1. #1
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    69

    Show delta value between two line graphs

    Friends,

    Need help. In a typical line graph where there are two lines, wondering how to represent the difference between each data point in the graph.

    For eg:
    X-axis: Jan, Feb, Mar etc..
    Y-axis: $ amounts from $10 to $100

    Data: Between two sales offices, show the $ for each month as line graphs.

    What is required: The delta portion between two line graphs - say for Jan - if the difference in amount is $5, then I want a dotted line connecting both dots and show this amount as difference amount. How can we achieve it?

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Show delta value between two line graphs

    Does this help?
    http://www.andypope.info/charts/Hilolabel.htm
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  3. #3
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    69

    Re: Show delta value between two line graphs

    Good one. But its not clear how does the line in the middle come up.. the middle line graph turns into a vertical line..how does this happen?

  4. #4
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    69

    Re: Show delta value between two line graphs

    Am using Excel 2013. How do I configure the 'Secondary X-axis' labels?

  5. #5
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Show delta value between two line graphs

    I don't know about 2013 but in when the instructions mention "apply the hi-lo lines", in 2010 that means you go to the chart tools in the ribbon and select the Layout tab. In the analysis section there is a button called "Lines." One of the options under that are to add "High-Low lines."

  6. #6
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    69

    Re: Show delta value between two line graphs

    I got the hi lo lines. But I tried using that procedure.. I couldn't get the diff number right in between the two line graphs. Can you pls help. Here is my data:

    Role Series A Series B Diff Label
    2B $23.10 $11.30 17.2 $(12)
    3A $23.10 $13.77 18.435 $(9)
    3B $23.10 $16.30 19.7 $(7)
    4A $23.10 $18.00 20.55 $(5)
    4A $23.10 $20.00 21.55 $(3)
    4B $23.10 $19.00 21.05 $(4)
    4B $23.10 $15.54 19.32 $(8)
    5A $23.10 $19.00 21.05 $(4)
    5B $23.10 $22.00 22.55 $(1)

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

    Re: Show delta value between two line graphs

    Move Diff line to secondary axis
    Set secondary axix category labels to column containing label data

    Add Line > Hi-Lo to SeriesA

    Select seriesA and use Design > Add Chart Element > Lines > High-Low Lines
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  8. #8
    Registered User
    Join Date
    02-13-2018
    Location
    Midlands
    MS-Off Ver
    365 Version 2208
    Posts
    10

    Re: Show delta value between two line graphs

    Hi,

    How do you expand the data set down on this example? On your kindly uploaded document, it is to rows deep and so the graph only runs to 9 entries. When i have tried to expand this in the select data series, and or when i have tried to edit the data series Horizontal (category) Axis Labels, it wont let me add additional? i need the table to expand to 35 lines of data in the graph? Other than that, this works perfectly for me

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Show delta value between two line graphs

    Coopereto welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Need help with line graphs
    By PaulSchulman in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-11-2014, 07:16 PM
  2. Line Graphs with all 0 values - line disappears
    By Robioto in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-15-2013, 08:27 AM
  3. line graphs
    By mrl in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-08-2013, 12:45 PM
  4. Creating line graphs to show a principle not actual values
    By emilieik in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-26-2010, 09:34 AM
  5. using line graphs to show trends
    By mwn in forum Excel General
    Replies: 3
    Last Post: 10-22-2009, 03:59 AM
  6. line graphs
    By slimjen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-11-2009, 04:50 PM
  7. [SOLVED] Line Column Graphs
    By Andy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2005, 07:06 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