Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Conditional chart formating
I need to format my charts so the color of the data points change depending
on the value amount. My tabels are already set up and cannot be change or have anything new added due to the amount and delicacy of data. Is there a macro I can use. Perhaps a formula I can put somewhere? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Conditional chart formating
Hi,
Ed Ferrero has a vba example. It's for a column chart but the code will be very similar. Instead of interior fill you will be doing marker stuff. eg: .MarkerBackgroundColorIndex = 50 .MarkerForegroundColorIndex = 50 Conditional Chart Formatting example. http://www.edferrero.com/charting.aspx Cheers Andy Mark wrote: I need to format my charts so the color of the data points change depending on the value amount. My tabels are already set up and cannot be change or have anything new added due to the amount and delicacy of data. Is there a macro I can use. Perhaps a formula I can put somewhere? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format of the Chart AREA COLOR | Excel Discussion (Misc queries) | |||
is there a conditional xls chart (ie change the graph dot color)? | Charts and Charting in Excel | |||
conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Urgent Chart Questions | Excel Discussion (Misc queries) |