LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change gradient color in chart for Excel 2007 NonTechie Charts and Charting in Excel 6 May 9th 23 03:43 AM
Chart issue--works in 2007, not in 2010 tmidgett Charts and Charting in Excel 0 February 8th 11 05:43 PM
Excel 2007 Chart - determining the color of a chart style Shane Devenshire[_2_] Charts and Charting in Excel 1 February 6th 10 04:09 AM
Saving chart templates - xl 2007 (and 2010?) Reg Charts and Charting in Excel 0 January 13th 10 03:36 PM
Excel 2007 chart gridline color using vba [email protected] Charts and Charting in Excel 2 December 17th 08 03:32 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"