+ Reply to Thread
Results 1 to 3 of 3

Stacked column with dollar data but adding horizontal line that is a %

  1. #1
    Registered User
    Join Date
    10-31-2006
    Posts
    61

    Stacked column with dollar data but adding horizontal line that is a %

    Hi All,

    I have been reading on the forum and other videos and such and I can't seem to make this work. I have attached a file for explanation purposes. I am having trouble getting the threshold line (in this case a horizontal line at the 50% marker) to display as part of my data set In all the examples I have looked at the threshold line is always the same format as the source data, eg, dollars and dollars or % and %. In my case what I am attempting to show with the data is if the proposed value is greater than 50% of the total of each stacked column (or visually falls below the below the 50% line) then that means it cost us more than we originally planned and vice versa.

    Any step by step help on the right way to accomplish this would be GREATLY appreciated.

    Thanks,

    Chris
    Attached Files Attached Files
    Last edited by waternut; 01-15-2016 at 09:24 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Stacked column with dollar data but adding horizontal line that is a %

    On the chart, select "threshold" series
    Right click the series and select Change Series Chart Type
    Choose LINE from the options.
    Attached Files Attached Files
    Last edited by protonLeah; 01-14-2016 at 05:39 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-31-2006
    Posts
    61

    Re: Stacked column with dollar data but adding horizontal line that is a %

    Hi Ben,

    Thanks for that, that was exactly what I needed. Just to add to the discussion, I have added how I can take the line and stretch it to the edges of the chart

    After getting the line on the chart,
    1) select the threshold line, right click> format data series > secondary axis
    2)select the chart > from the ribbon > add chart element > axis > secondary horizontal
    3) select the secondary horizontal axis (in my case its on the top of the chart > choose axis options from the format axis options >axis position choose "on tick marks"
    4) in the same format axis section under tick marks > major type =none >minor type = none, > and under labels, label position = none
    5) select the secondary vertical axis on the chart > delete

    That should then put your threshold marker back in the right position and clean up the chart.

    Thanks again for your help!!!!!

    C.

+ 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. [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. Issue with adding vertical line to stacked column
    By btmansfi in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-13-2014, 01:07 PM
  3. Adding horizontal line to VBA column chart
    By the_adam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2013, 09:56 AM
  4. Stacked waterfall chart with horizontal line
    By kalam1989 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-28-2013, 12:42 PM
  5. Replies: 2
    Last Post: 05-16-2010, 11:23 PM
  6. stacked column/bar chart w/ monthly data + single line of daily data
    By dommarsh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2008, 11:29 PM
  7. combination stacked column and line data
    By Cowtoon in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-10-2006, 03:35 PM
  8. How do i add a line graph onto a stacked column chart using data
    By Nicola in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2005, 11:05 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