+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting of Data Series in a chart

  1. 08-27-2008, 05:53 AM #1
    joe90
    joe90 is offline
    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
    Reply With QuoteRegister To Reply
  2. 08-27-2008, 06:17 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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 / VBA / Macros
    Replies: 0
    Last Post: 08-08-2008, 05:56 PM
  2. Finding the internal index number of a Chart Series.
    By Phil Outram in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2008, 04:19 PM
  3. DDE Macros and data formatting
    By JMann in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-28-2008, 05:33 AM
  4. Conditional Formatting Formula for zig zagging data
    By ChemistB in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2007, 11:01 AM
  5. Going insane!
    By kik in forum Excel - New Users/Basics
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1