+ Reply to Thread
Results 1 to 2 of 2

conditional formatting of chart

  1. #1
    Registered User
    Join Date
    florida, usa
    MS-Off Ver

    conditional formatting of chart

    The following is the chart I am trying to change.

    sheet 4.PNG

    This is a snapshot from the excel sheet where the colors change based on conditional formatting. That is, if the numbers are <=1 the result is a white box, and if the values are between 1 and 10 there is a color range between yellow and red.

    sheet 5.PNG

    Is it possible to apply this idea to the chart so that when numbers are updated so is the chart? There various colors on the first chart are arbitrary.

  2. #2
    Join Date
    Worcester MA
    MS-Off Ver
    Excel 2003

    Re: conditional formatting of chart

    Check out my tutorial, Conditional Formatting of Excel Charts.
    Jon Peltier

+ 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. Pie Chart - Conditional Formatting with VBA
    By clutch12 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-03-2010, 06:19 AM
  2. Conditional Chart Formatting
    By Immortal Lobster in forum Excel General
    Replies: 2
    Last Post: 04-02-2009, 07:10 PM
  3. chart conditional formatting
    By bob777 in forum Excel General
    Replies: 1
    Last Post: 11-28-2005, 06:50 AM
  4. Conditional formatting a bar chart
    By Caro-Kann Defence in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-13-2005, 11:05 AM


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