+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    05-27-2008
    Posts
    7

    Conditional Formatting of Data Series in a chart

    Is it possible to add conditional formatting to a data series in a chart?
    e.g. If a value in a series exceeds a certain point the graphical element changes colour..

    Thanks
    Joe

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944
    Yes it's possible but you need to add additional series and the value of the series is based upon formula.

    http://peltiertech.com/Excel/Charts/...nalChart1.html

    If you need more help post back with example workbook.
    Cheers
    Andy
    www.andypope.info

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort and chart multiple series from raw data using macros
    By RoseyCindy in forum Excel Programming
    Replies: 0
    Last Post: 08-08-2008, 06:56 PM
  2. Finding the internal index number of a Chart Series.
    By Phil Outram in forum Excel Programming
    Replies: 0
    Last Post: 08-04-2008, 05:19 PM
  3. DDE Macros and data formatting
    By JMann in forum Excel Programming
    Replies: 12
    Last Post: 03-28-2008, 06:33 AM
  4. Conditional Formatting Formula for zig zagging data
    By ChemistB in forum Excel Worksheet Functions
    Replies: 4
    Last Post: 05-03-2007, 12:01 PM
  5. Going insane!
    By kik in forum Excel - New Users
    Replies: 10
    Last Post: 01-31-2007, 08:21 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.2.0