+ Reply to Thread
Results 1 to 2 of 2

Bar with Max and Min to be of Different Colour

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Bar with Max and Min to be of Different Colour

    Hi, the attached is a sample of Salary of different field and their Max and min salary.
    Its like the Football Chart. However, i want to better make those with the Max and Min Salary stand out.
    I am using a Excel 2010. Can it be done?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Bar with Max and Min to be of Different Colour

    Yes it is.

    Instead of 1 series to plot the floating bar you need 3.
    Then formula to determine the value for each point in the 3 series.

    See attached example
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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] Apply background colour and font colour on sheets following specific naming pattern
    By annazet in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2018, 07:05 AM
  2. Replies: 6
    Last Post: 04-11-2016, 09:48 AM
  3. [SOLVED] Search cells based on student name, cell background colour and return a tally for colour
    By drof_06 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-26-2016, 04:31 AM
  4. Replies: 2
    Last Post: 02-13-2015, 03:06 PM
  5. Replies: 3
    Last Post: 02-13-2014, 06:31 AM
  6. Replies: 1
    Last Post: 09-12-2013, 02:09 PM
  7. Macro that clears contents of all cells of certain colour (colour 35) in all sheets
    By Hanskubansku in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-25-2012, 07:33 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