Results 1 to 3 of 3

Need help on making a horizontal line on my chart touch the Y-axis

Threaded View

haffi_thegreat Need help on making a... 10-29-2013, 09:13 AM
Andy Pope Re: Need help on making a... 10-29-2013, 10:34 AM
haffi_thegreat Re: Need help on making a... 10-29-2013, 10:56 AM
  1. 10-29-2013, 10:34 AM #2
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Need help on making a horizontal line on my chart touch the Y-axis

    move the line to the secondary axis.
    add secondary horizontal axis.
    Format Axis crosses on tick marks.
    set tick labels and major marks to none.
    set line to none
    delete secondary vertical axis
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating horizontal line chart with categories in y-axis
    By riya.arora. in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-09-2013, 04:55 AM
  2. [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
  3. [SOLVED] Connect each scatter chart point to left-side Y-axis with its own horizontal line
    By JayUSA in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 06:50 PM
  4. Line up secondary vertical axis with the primary horizontal axis
    By cbo in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-07-2010, 02:54 PM
  5. Chart using one column as vertical axis and others on horizontal axis!!!
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2007, 09:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1