Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I apply conditional formatting to axis labels?
I would like to apply conditional formatting to my horizontal axis based on
the value of that data point. If the value exceeds a threshold it would cause the category axis label for that point to change font, color, etc. or I would like to apply conditional formating to a series based on the value of the data point in the series. If the value excedds a threshold it would cause the bar (bar graph) for that point to be different from the others. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I apply conditional formatting to axis labels?
Axis labels are treated as a unit, you can't format individual labels.
You could set up a dummy axis and use VBA to control its formatting. You can see samples at Jon Poltier's website of dummy axes. http://peltiertech.com/Excel/Charts/ -- If this helps, please click the Yes button. Cheers, Shane Devenshire "erwatt" wrote: I would like to apply conditional formatting to my horizontal axis based on the value of that data point. If the value exceeds a threshold it would cause the category axis label for that point to change font, color, etc. or I would like to apply conditional formating to a series based on the value of the data point in the series. If the value excedds a threshold it would cause the bar (bar graph) for that point to be different from the others. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Apply to Charts? | Charts and Charting in Excel | |||
I need conditional formatting to apply to maximum % | Excel Worksheet Functions | |||
How do I apply conditional formatting? | Excel Worksheet Functions | |||
Can I Apply Conditional Formatting to a Chart? | Charts and Charting in Excel | |||
How do I apply conditional formatting to a text box | Excel Worksheet Functions |