Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Bar Chart: Conditional formatting

  1. #1
    Join Date
    7th December 2005
    Posts
    12

    Bar Chart: Conditional formatting

    How does one apply conditional formats to the bars in a bar chart. I am measuring performances of various functions and have them recorded by percentage. The cells the percentages have conditional formats, ie., if performance drops below a certain percentage it turns yellow, then if it goes below a lesser percentage, it turns red. I cannot find anything on this anywhere yet I have seen it done before. Thanks and Merry Christmas.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    Re: Bar Chart: Conditional formatting

    As Andy Pope has written elsewhere on the forum, conditional formatting on charts is very limited. My first thought to apprach your problem, is to change the appearance of the chart using vba. To record some code, use the macro recorder. You just record while you manually change the color of say a bar chart. Then go to the code in the modules in VBA. What you then have to do is, I'm just thinking loudly, substitute in the conditions you used in the conditional formatting, based on the cell values. That is, you use 1 or more ifs to assign for instance the color of a bar chart. The conditions are those you used in the conditional formatting as well. Merry Christmas to you too David. Let us know if you proceed.

    Wigi
    Last edited by Wigi; December 23rd, 2005 at 01:21.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  3. #3
    Join Date
    7th December 2005
    Posts
    12

    Re: Bar Chart: Conditional formatting

    Criteria:

    <80% = Red
    >=80% and <85% = Yellow
    >=85% = Green

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    Re: Bar Chart: Conditional formatting

    As I said, go out experimenting with the macro recorder. Just select parts of the bar chart (those you want to change their color) and actually change it in a color like red. Then see how you should write that in VBA code. Then, change a few things to incorporate the conditional formatting. I suggest to play around with the macro recorder, and if you're stuck then, upload a small example file. It's difficult for us to see how your actual file looks like in detail. I cannot write in general the formulas you have to use.

    Wigi
    Last edited by Wigi; December 23rd, 2005 at 01:34. Reason: typo
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  5. #5
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Bar Chart: Conditional formatting

    Hi,

    This is a non vba approach. You just need a series for each colour and a formula that only displays the value within the correct band.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Cheers
    Andy


  6. #6
    Join Date
    29th November 2010
    Posts
    1

    Re: Bar Chart: Conditional formatting

    Quote Originally Posted by Andy Pope View Post
    Hi,

    This is a non vba approach. You just need a series for each colour and a formula that only displays the value within the correct band.
    Thanks Andy
    U r a legend

    Cheers

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Conditional Line Graph / Chart Formatting
    By Manguish in forum EXCEL HELP
    Replies: 7
    Last Post: May 30th, 2012, 08:40
  2. Conditional Chart Series Formatting
    By foehammer888 in forum EXCEL HELP
    Replies: 1
    Last Post: September 13th, 2007, 16:43
  3. Replies: 4
    Last Post: May 22nd, 2006, 22:19
  4. conditional formatting chart data table
    By Tim_R in forum EXCEL HELP
    Replies: 2
    Last Post: October 7th, 2005, 00:23

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
  •  
porno