Results 1 to 5 of 5

Issue with adding vertical line to stacked column

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    Chesapeake, VA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Issue with adding vertical line to stacked column

    I've attached the file. My goal was to add a vertical line (retirement year) to the stacked columns to provide a visual aid to better distinguish working years from retirement years. I was successful at adding the vertical line. BUT...for some reason it stays at the first year and will not move to the right.

    I added a line graph on the seconday axis with (X,Y) values of (2044,0) and (2044,1). It even shows that when I hover over the points on the chart. However, the line is angles instead of straight and it is not centered on 2044 - it's center on 2014.

    Help please!!

    Thanks,
    Brian
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to add a vertical line graph on a stacked horizontal bar chart?
    By Why123 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-14-2015, 07:20 PM
  2. [SOLVED] Display vertical line on stacked line chart already using primary and secondary axises
    By ben_hensel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2012, 10:21 AM
  3. Replies: 2
    Last Post: 05-16-2010, 11:23 PM
  4. Adding line to a stacked bar chart
    By ritz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-12-2007, 03:57 AM
  5. Adding a vertical line to a column chart
    By Bill Goszinski in forum Excel General
    Replies: 1
    Last Post: 07-28-2006, 07:55 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