| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I Apply Conditional Formatting to a Chart?
I don't agree with my boss's ideas regarding Excel Charts - I think that they
are to cluttered and become less effective. So, I would like to apply conditional formatting via a checkbox to "turn off"(apply white/transparent properties)to one or more series in a chart, effectively eliminating the overlapping series from view temporarily. Can this be done? Is the answer VB?I think this could be very effective in clarifying data that is consistently overlapping each other. (Actually I would just make 3 separate charts on the same page, but nobody is asking me!) Tell me what you think... Thanks, Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does special formula apply to conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
| Conditional formatting in a chart | Charts and Charting in Excel | |||
| How do I apply conditional formatting to a text box | Excel Worksheet Functions | |||
| How to apply conditional formatting with incremental address for . | Excel Worksheet Functions | |||
Threaded Mode
