Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Display A Custom Benchmark Line Across Graph Plot Area

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0

    Display A Custom Benchmark Line Across Graph Plot Area

    Is there anyway of displaying a permanent line across the graph area to mark a benchmark of 80% ?

    Can the line remain visible at all times even when all scores are deleted from the cell range for scores

    Cheers

    Reg


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 06-12-2023 at 05:51 PM.

  2. #2
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0
    Last edited by DocAElstein; 06-12-2023 at 05:50 PM.

  3. #3
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Can be done by using VBA or else you need to do it manually every time.

  4. #4
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0
    Could you please post a code.Thanking you

  5. #5
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0
    Hi LalitPandey87

    Would you please have VBA code for permanent line across the graph area to mark a benchmark of 80%

    Thank you

    Reg

  6. #6
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Here's a way to do it without VBA. The original chart on top shows a color gradient towards the 100% mark. This is done using a picture inserted within the plot area. Note that this is only done by fixing the maximum axis value to 100, and using an appropriate picture.

    What you've asked for though is the second chart. Here it is hard coded, to have a line at 80% (well, absolute 80 actually). If you want to increase the number of points, you'll have to increase it manually within the series by selecting the series and going to the formula bar. And of course you can see that that I've used a Line Chart
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  7. #7
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0
    Hello ExcelFox

    I just created this chart as you posted your attempt.I will post it anyway as I look at your file.I have a cell which I place what percentage marker line I require and somehow the Lines would adjust....I suspect VBA for this trick

    Cheers

    Regc
    Attached Files Attached Files

  8. #8
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Here's a non-VBA version. Note that I've used named ranges, to make it easier. You can delete the Score range, that is not needed. Again, I've fixed this to 15 data points. So if you need more or less, you have to make the adjustments.



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 06-12-2023 at 05:52 PM.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  9. #9
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0
    Again thank you Excel Fox

    All works very good.That is exactly what I wanted

    This is a final request on this post....is it possible that I can hide columns within the score/graph column range D to R and the Bars and Scores also hide for the selected columns....at present if I hide say 4 columns ( I to L) within the score range the Bars in the Graph do not line up to there score and there are 4 scores at the end with no Bars......can the Graph adjust accordingly when Columns are hiiden

    Thanks
    Attached Files Attached Files

  10. #10
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    For that you'll need to use another range of data.
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Trick of the Week :: Custom Views to Control Workbook Display Options
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 07-31-2013, 03:30 PM
  2. How To Create A Graph In Excel
    By rich_cirillo in forum Excel Help
    Replies: 6
    Last Post: 06-22-2013, 04:55 PM
  3. How to Add Custom List And Use in Custom Sorting
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-07-2013, 10:41 PM
  4. Print Selective Area
    By r_know in forum Excel Help
    Replies: 2
    Last Post: 06-21-2012, 11:09 PM
  5. Replies: 4
    Last Post: 05-03-2012, 10:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •