+ Reply to Thread
Results 1 to 4 of 4

Bold Horizontal line need to be plotted

  1. #1
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    657

    Bold Horizontal line need to be plotted

    Hello Friends

    Please find the attached file (Bold Horizontal line need to be plotted.xlsx).

    In Secondary axis I need to create a bold horizontal line for 0, +1 and -1.

    thanks in advance.
    Attached Files Attached Files
    Sekar

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Bold Horizontal line need to be plotted

    This may or may not be helpful. I changed the chart type to a line chart with markers, then modified the instructions found in this article to make horizontal lines that are tied to the secondary axis. Here is a copy of the file attached to post #1 with the horizontal lines applied: Copy of Bold Horizontal line need to be plotted.xlsx
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    657

    Re: Bold Horizontal line need to be plotted

    Hello JeteMc

    This is Alternate thinking really helpful, thanks

    thanks again

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Bold Horizontal line need to be plotted

    You're Welcome and thank you for the feedback. If that takes care of your original question, please select Thread Tools from the menu link above your first post and mark this thread as SOLVED. I hope that you have a good day.

+ 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] Make the Zero line bold
    By mra1984 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-08-2017, 06:27 PM
  2. Replies: 7
    Last Post: 08-20-2013, 03:59 PM
  3. Line chart and margins before and after the plotted data
    By simone77 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2012, 02:14 PM
  4. [SOLVED] hide zero values plotted on a line graph
    By Koda7 in forum Excel General
    Replies: 4
    Last Post: 06-27-2012, 09:25 AM
  5. 2 values stacked, 3rd value plotted as line
    By more_Qs_than_As in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-16-2007, 05:07 PM
  6. Replies: 2
    Last Post: 08-15-2006, 03:20 PM
  7. [SOLVED] How do I stop plotted data from going to zero in a line chart?
    By Dozier in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-19-2005, 03:05 PM
  8. [SOLVED] Horizontal line on line chart
    By Lee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2005, 03:06 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