+ Reply to Thread
Results 1 to 2 of 2

Horizontal lines on line chart

  1. #1
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    74

    Horizontal lines on line chart

    HI
    How do I create a horizontal line through specific value on Y Axis? For exple I want to create three horizontal lines at values 0.9, 1.0 & 1.05 on attached line graph. Is there a way to create line with given values withour barely drawing crude line using FORMAT and line market on tools.
    Attached Files Attached Files

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

    Re: Horizontal lines on line chart

    My first thought is one of the techniques described by Jon Peltier here: https://peltiertech.com/Excel/Charts/AddLine.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Individual horizontal lines in Excel chart
    By annanders in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-06-2016, 05:43 AM
  2. Horizontal bar chart with target lines
    By golfoscar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-08-2014, 03:57 AM
  3. Horizontal Lines on Waterfall Chart
    By BoomerSooner2014 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-21-2014, 01:30 PM
  4. add horizontal lines to stock chart
    By freak11 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-15-2013, 07:32 AM
  5. [SOLVED] How to create line chart in excel having horizontal lines from Y axis
    By pnperl in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-16-2012, 01:40 PM
  6. problem with horizontal lines in chart
    By Meenie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-17-2009, 01:06 AM
  7. Horizontal lines in waterfall chart
    By Tim in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-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