Thread: Series Format

Hi Everyone,

Is there a way in VBA to identify a series and set the format (specifically color). Basically, each week we have a database out put in the same format then brought over to excel. Problem is each series has a "special" color it has to be. I was thinking by putting sheet VBA on the chart sheets I could control the color of the bar graphs based on series name.

For example:

If series = "America" color is red

Obviously I have understated it, but that is the general idea.

Thanks!

Regards,
Matt

Anyone have any thoughts or references to check out??

Cheers,
Matt