Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting in a chart
Does anyone know is it possible to do conditional formatting for a data
series in a Excel chart? If yes, how to do it? I have used this fuction in the worksheets but have not been able to do it for a chart. |
#2
|
|||
|
|||
Not really in the chart, but you can set up extra data series which will
plot in the format you want and make the series use only the data you want. You can also use a macro tro change display information, but this can be awkward depending on what you want the "conditional" to do "Baro" wrote: Does anyone know is it possible to do conditional formatting for a data series in a Excel chart? If yes, how to do it? I have used this fuction in the worksheets but have not been able to do it for a chart. |
#3
|
|||
|
|||
This web page shows how to get the same effect with multiple series:
http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Baro wrote: Does anyone know is it possible to do conditional formatting for a data series in a Excel chart? If yes, how to do it? I have used this fuction in the worksheets but have not been able to do it for a chart. |
#4
|
|||
|
|||
Hi Baro,
A bit late maybe, but I have found a way to copy worksheet conditional formatting to a chart. You can find a sample here http://edferrero.m6.net/charting.aspx Look for Conditional Chart Formatting Ed Ferrero http://edferrero.m6.net Does anyone know is it possible to do conditional formatting for a data series in a Excel chart? If yes, how to do it? I have used this fuction in the worksheets but have not been able to do it for a chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |