+ Reply to Thread
Results 1 to 5 of 5

Add vertical lines in chart

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    10

    Add vertical lines in chart

    Hi

    I have attached a graph with 4 x 2 red vertical lines inserted manually for each gap. How would i enter some values to the data so these vertical lines are automatically inserted instead of manually inserting?
    Is this possible?

    Also how do i have a 30 minute gap for the times instead of 144 minute intervals?

    Thank you

    Zac
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Add vertical lines in chart

    To alter the minute gap change the Major value. 00:30 = 0.020833333333333

    The vertical lines could be done using additional series. Either by plotting the xy points, although this will require 2 entries for a given time. Or add vertical error bars but you will have to fix the maximum vertical axis or move that series to the secondary axis.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Add vertical lines in chart

    Thanks Andy

    Would you have time to post back an excel spreadsheet demonstrating your recommendations for the vertical lines?

    Thanks again

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Add vertical lines in chart

    I have added a series with Minus Y error bar of 100%.

    You will get a red line wherever you enter 16000.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Add vertical lines in chart

    Excellent Andy

    Thank you

+ 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. Replies: 5
    Last Post: 04-04-2019, 02:39 PM
  2. Gantt Chart Vertical Lines
    By gcaulfield88 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-26-2014, 05:04 AM
  3. Vertical lines on a chart?
    By ryanjb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-25-2013, 05:38 AM
  4. Vertical Lines - Area Chart
    By negcx in forum Excel General
    Replies: 3
    Last Post: 12-30-2008, 07:29 AM
  5. Add 2 vertical lines to bar chart
    By thei in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-25-2008, 04:38 PM
  6. Vertical lines in a line chart
    By Enna in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-01-2006, 07:10 AM
  7. Replies: 3
    Last Post: 03-03-2006, 12:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1