+ Reply to Thread
Results 1 to 3 of 3

Trouble highlighting lowest value in excel chart

  1. #1
    Registered User
    Join Date
    09-01-2019
    Location
    Chapel Hill, NC
    MS-Off Ver
    365
    Posts
    1

    Trouble highlighting lowest value in excel chart

    All,

    I'm a bit stuck with a clustered column chart. I'm trying to automatically highlight in red the lowest value in each cluster, but haven't been able to successfully adopt the max/min & 100% overlap method to get me where I need to be. Thoughts?

    clustered column.PNG

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Trouble highlighting lowest value in excel chart

    I don't think we can help much with just a picture. Can you upload a sample file (anonymized as needed) with your attempts at creating the effect? It would probably also help if you could describe (or link to a tutorial with a description) the procedure you are trying to use.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Trouble highlighting lowest value in excel chart

    Hi and welcome to the forum.

    Uploading the workbook would be a big help. Neither am I clear what you're getting at when you mention the overlapping. WHat are you wanting to achieve with that.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Highlighting the lowest of 3 results. How to do?
    By macfms in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2016, 08:54 AM
  2. Highlighting lowest value - conditional formatting
    By inzanesrt4 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-08-2015, 05:42 PM
  3. [SOLVED] Conditional formatting - highlighting lowest value per row
    By nostrum in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 04-06-2014, 04:22 PM
  4. Trouble highlighting only four lowest numbers in a row
    By tankmccuin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2014, 08:47 PM
  5. Replies: 6
    Last Post: 02-16-2013, 07:29 AM
  6. Joining two lists & highlighting lowest value
    By Coin in forum Excel General
    Replies: 7
    Last Post: 03-30-2011, 01:46 PM
  7. Highlighting lowest value automatically?
    By bould in forum Excel General
    Replies: 2
    Last Post: 03-21-2011, 05:27 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