View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lina Lina is offline
external usenet poster
 
Posts: 20
Default Set color for chart serie in excel 2007/2010

Hi!
I want to do a macro that sets the color for the chart series to the color
the company has desided to use. We have a theme but we can only set color for
the first 6 series and we often use much more series.
I have understod that this isnt so easy as to loop thru the series and set
the color since the color is set on different ways depending on the charttype
for the serie, or is it a way to do this so it works for all chart types?

thanks