+ Reply to Thread
Results 1 to 6 of 6

Min and Max data label coloring

  1. #1
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Min and Max data label coloring

    Hi,

    I would need your help regarding dynamic data label coloring.
    My target is to color by green the max value and by red the min value.

    See the actual status of the chart in attached.

    Thank you in advance the help!
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Min and Max data label coloring

    You can sort of fake it with adding data label to Max and Min series, and making it Solid fill to hide what's behind it.

    For something more robust, you'll likely need VBA.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Min and Max data label coloring

    If I understood your requirement correctly, you can try something like this.
    Right click on Sample Sheet Tab --> View Code --> Paste the code given below into the opened code window --> Close the VB Editor --. Save your workbook as Macro-Enabled Workbook.
    Please Login or Register  to view this content.
    Last edited by sktneer; 03-23-2017 at 05:39 AM. Reason: Removed unnecessary line of code which was Debug.Print
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Min and Max data label coloring

    In order to have robust result, what would be the best VBA way?

  5. #5
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Min and Max data label coloring

    Thank you very much sktneer!

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Min and Max data label coloring

    You're welcome Villalobos! Glad I could help.

+ 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. Pivot Chart not displaying data label values for the first Legend label
    By zykkzxxy789077 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 05:46 AM
  2. Follow hyperlink stored in label controltiptext when clicking on userform label
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2015, 08:24 AM
  3. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  4. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  5. Waterfall Chart with automatic coloring and text coloring
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2013, 05:54 PM
  6. coloring rows if data found
    By NewToExcel-2007 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-04-2010, 06:45 PM
  7. extend the coloring without affact other data
    By yjmmay34 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2010, 10:10 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