+ Reply to Thread
Results 1 to 5 of 5

Adding a horizontal line to a Graph

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Adding a horizontal line to a Graph

    Hi All. In the graph in the attached workbook, is there a way to add a horizontal line between 20 & 21 please?

    It's to indicate relegation.

    If it is possible maybe a thin dotted line would be best.

    Any assistance gratefully received.
    Attached Files Attached Files
    Last edited by Marvo; 02-14-2024 at 08:55 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Adding a horizontal line to a Graph

    Hi there,

    Take a look at the attached version of your workbook and see if it does what you need - a "Relegation" column has been added as Column B.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Adding a horizontal line to a Graph

    Like this?
    Attached Files Attached Files
    Rory

  4. #4
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Adding a horizontal line to a Graph

    Those are both fine guys, thank you very much.

  5. #5
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Adding a horizontal line to a Graph

    Hi again,

    Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

+ 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] Line / Combo Chart - Adding a solid horizontal line from one data cell
    By TimLevs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-29-2023, 05:51 AM
  2. Graph - Horizontal line in scatter graph & intercept
    By natkemon in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2018, 11:50 AM
  3. Horizontal Band Graph with line graph
    By ExcelDummy77 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-22-2016, 01:11 PM
  4. [SOLVED] How to add a horizontal line to a graph
    By BNCOXUK in forum Excel General
    Replies: 3
    Last Post: 10-29-2012, 11:20 AM
  5. Adding Horizontal line to a graph
    By WhytheQ in forum Excel General
    Replies: 1
    Last Post: 06-14-2006, 09:45 PM
  6. [SOLVED] Possible to Add Horizontal Line to Embedded Graph via VBA?
    By TimSchwaar in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-29-2005, 07:05 PM
  7. Possible to Add Horizontal Line to Embedded Graph via VBA?
    By TimSchwaar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2005, 07:05 PM

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