+ Reply to Thread
Results 1 to 2 of 2

Stoppage line on line chart

Hybrid View

schnett Stoppage line on line chart 08-07-2007, 02:04 PM
Ron Coderre Stoppage line on line chart 08-07-2007, 02:36 PM
  1. #1
    Registered User
    Join Date
    07-20-2004
    Posts
    40

    Stoppage line on line chart

    I have a a few series of data on my line chart like this :

    2003-03 0.2 0.7
    2003-04 0.0 0.8
    2003-05 0.1 0.6
    2003-06 0.0 0.1
    2003-07 0.0 0.6
    2003-08 0.0 0.7
    2003-09 0.0 0.8
    2003-10 0.1 0.7
    2003-11 0.0 0.4
    2003-12 0.1 0.7
    2004-01 0.0 0.4
    2004-02 0.1 0.3
    2004-03 0.0 1.1
    2004-04 0.0 0.4
    2004-05 0.1 1.5
    2004-06 0.1 0.8
    2004-07 0.0 0.3
    2004-08 0.2 0.7
    2004-09 0.0 0.7

    I would like to have a vertical line on my chart that I update every quarter. For example :
    1st qtr => at 2003-10 a vertical line from 0.0 to 2.0.
    2nd qtr => at 2004-01 a vertical line from 0.0 to 2.0.
    The problem is my chart is not an xy chart.

    I know how to put a line on the chart manually but I don't know how to do it automatically.

    Can anyone help ?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Stoppage line on line chart

    Maybe something like this....

    Add an extra data series to the right of the current data:

    2003-03 0.2 0.7
    2003-04 0.0 0.8
    2003-05 0.1 0.6
    2003-06 0.0 0.1
    2003-07 0.0 0.6
    2003-08 0.0 0.7
    2003-09 0.0 0.8
    2003-10 0.1 0.7 0.2<--------
    2003-11 0.0 0.4
    2003-12 0.1 0.7
    2004-01 0.0 0.4 0.2<---------
    2004-02 0.1 0.3
    2004-03 0.0 1.1
    2004-04 0.0 0.4
    2004-05 0.1 1.5
    2004-06 0.1 0.8
    2004-07 0.0 0.3
    2004-08 0.2 0.7
    2004-09 0.0 0.7

    Add that data series to the chart. (It will initally plot like your other series)

    Next, right click on the new series and select Format Series.
    Y-Error Bar Tab:
    -Select the dot with the drop line
    -Set the Error Amount to Fixed Value: 0.2
    Patterns Tab:
    -Marker: None
    Click [OK]

    Right-click on one of the Error Bars
    Patterns Tab:
    Set the line color and weight.

    You should now have 2 vertical lines from 0 to 0.2 marking the 2 quarters.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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