|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
08-27-2008, 06:53 AM
|
|||
|
|||
|
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
08-27-2008, 07:17 AM
|
||||
|
||||
|
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.
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sort and chart multiple series from raw data using macros | RoseyCindy | Excel Programming | 0 | 08-08-2008 06:56 PM |
| Finding the internal index number of a Chart Series. | Phil Outram | Excel Programming | 0 | 08-04-2008 05:19 PM |
| DDE Macros and data formatting | JMann | Excel Programming | 12 | 03-28-2008 06:33 AM |
| Conditional Formatting Formula for zig zagging data | ChemistB | Excel Worksheet Functions | 4 | 05-03-2007 12:01 PM |
| Going insane! | kik | Excel - New Users | 10 | 01-31-2007 08:21 AM |
Linear Mode
