+ Reply to Thread
Results 1 to 2 of 2

conditional formatting of chart

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    florida, usa
    MS-Off Ver
    360
    Posts
    34

    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
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: conditional formatting of chart

    Check out my tutorial, Conditional Formatting of Excel Charts.
    Jon Peltier
    http://PeltierTech.com/

+ 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

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