+ Reply to Thread
Results 1 to 3 of 3

Connect each scatter chart point to left-side Y-axis with its own horizontal line

  1. #1
    Forum Contributor
    Join Date
    04-26-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2016
    Posts
    241

    Connect each scatter chart point to left-side Y-axis with its own horizontal line

    Hi Everyone,

    Is there a simple way to have a scatter chart automatically show a horizontal line to the left of each scatter point, connecting the point to its relative value on the Y=axis. For aesthetic reasons, I'm hoping to do this and avoid the use of Excel's built-in grid lines.

    Thanks & cheers!

    Jay
    Last edited by JayUSA; 06-18-2012 at 10:17 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,211

    Re: Connect each scatter chart point to left-side Y-axis with its own horizontal line

    Try using a left horizontal error bar set to an appropriate percentage (100% if the y axis is at x=0).

  3. #3
    Forum Contributor
    Join Date
    04-26-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2016
    Posts
    241

    Re: Connect each scatter chart point to left-side Y-axis with its own horizontal line

    Great idea! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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