+ Reply to Thread
Results 1 to 2 of 2

how to enable automatic color formatting of bar graph based on a criteria/s

Hybrid View

  1. #1
    Registered User
    Join Date
    10-14-2022
    Location
    Perth, Australia
    MS-Off Ver
    Office 365
    Posts
    4

    how to enable automatic color formatting of bar graph based on a criteria/s

    I am trying to format my bar chart so that any bars above a certain value will be formatted to a certain color and any bars below a certain value will be formatted to another color. A colleague sent me snip of this bar chart but he hasn't sent me the spreadsheet. thanks for the help.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,438

    Re: how to enable automatic color formatting of bar graph based on a criteria/s

    The typical first suggestion is something like this https://peltiertech.com/conditional-...-excel-charts/

    Would you be allowed to add the necessary helper columns for a technique like that?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Color Bar Graph Based on Color of Cell
    By BenChod1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2022, 12:09 PM
  2. Replies: 1
    Last Post: 09-18-2018, 04:57 PM
  3. Replies: 2
    Last Post: 04-14-2018, 12:03 PM
  4. [SOLVED] Automatic Bar Graph with color
    By manish Joshi07 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-22-2015, 03:03 AM
  5. Automatic formatting of cells based on rules/criteria
    By ioannes in forum Excel General
    Replies: 1
    Last Post: 07-30-2014, 03:55 AM
  6. Conditional Formatting and Automatic Filter by color
    By kapilrakh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2013, 02:05 AM
  7. Automatic color based on color in other cell
    By Bramjonker in forum Excel General
    Replies: 3
    Last Post: 05-22-2013, 05:17 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