+ Reply to Thread
Results 1 to 3 of 3

Vertical lines on a chart?

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Salt Lake City, Utah
    MS-Off Ver
    365
    Posts
    19

    Vertical lines on a chart?

    I am creating a forecasting report with a basic line graph (chart) and I am having trouble figuring out how to put in a vertical line in my line graph. I have a 52 week chart and would like to show separation for the different seasons of the year. So what I want is a vertical line on weeks 13, 26, and 39. I tried to add another legend series at each of those points (13, 26, 39), but when I do that it comes out as a triangle, which makes sense. Any other ideas on how I could accomplish this? Thanks for any help and ideas!
    -Ryan

  2. #2
    Registered User
    Join Date
    01-24-2013
    Location
    Salt Lake City, Utah
    MS-Off Ver
    365
    Posts
    19

    Re: Vertical lines on a chart?

    I figured one way to do it. It takes some time to accomplish it, but it works.
    http://www.exceldashboardtemplates.c...el-line-chart/

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

    Re: Vertical lines on a chart?

    add a series to the secondary axis and add drop lines.

    or maybe you could simply use multi level axis labels
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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