Conditional chart formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 31 Aug 2006 20:50 GMT

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?

Reply to this Message

Andy Pope - 31 Aug 2006 21:06 GMT

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

> 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?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message