+ Reply to Thread
Results 1 to 3 of 3

add dynamic vertical line to column chart

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    add dynamic vertical line to column chart

    Hello. How can I add a dynamic vertical line based of a cell value in a column chart? Preadpeat appached.
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: add dynamic vertical line to column chart

    Step-by-step instruction in attachment. Basically: add dummy series and present it as scatterplot. It can be either 2-points: (4.5,0) and (4.5,18) or even just one point and error bar - I did it this way.

    Final touch left for you in attachment -> change y for the point to 0 (I started from 1 because otherwise the red bar at first step would not be visible).

    So the steps are:
    add dummy series
    changed dummy series to scatterplot type
    edit dummy series, add X value (bars have only Y Value)
    add error bars, subtype: custom
    delete legend entry
    do formatting of:
    error bar
    series point
    vertical axis

    Done!
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: add dynamic vertical line to column chart

    Boom. Impressive!!

+ 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. Vertical line in a histogram (vertical bar chart)
    By AdamCPTD in forum Excel General
    Replies: 2
    Last Post: 11-18-2017, 03:04 AM
  2. Column chart with vertical line
    By ali_excelforum in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-05-2015, 03:45 PM
  3. Replies: 2
    Last Post: 09-03-2013, 09:18 AM
  4. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  5. [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
  6. Vertical Line in Column Chart
    By Beginner Level in forum Excel General
    Replies: 7
    Last Post: 03-15-2012, 02:12 AM
  7. 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