PC Review


Reply
Thread Tools Rate Thread

Changing Chart Data Series

 
 
=?Utf-8?B?c2h1bg==?=
Guest
Posts: n/a
 
      3rd Jan 2006
Is is possible to change a chart's series color with vba code?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?c2h1bg==?=
Guest
Posts: n/a
 
      11th Jan 2006
It is possible to change chart's data series color with vba code. I used the
following code:


mychart.SeriesCollection(1).Interior.ColorIndex = 12


I did a little playing around and I finally got it.

Hope this can be helpful to someone else.

"shun" wrote:

> Is is possible to change a chart's series color with vba code?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
chart with two data series and two colors for each data series bikash Microsoft Excel Charting 0 17th Jan 2008 03:04 AM
chart series data corrupted when chart has no data =?Utf-8?B?dGltcA==?= Microsoft Excel Programming 0 11th Apr 2006 11:23 PM
chart data series -- plot a table as a single series =?Utf-8?B?aGpj?= Microsoft Excel Charting 7 20th Sep 2005 05:52 PM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Microsoft Excel Charting 3 30th Mar 2005 06:23 PM
can I hide a series in a stacked bar chart but keep the series in the data table jcknortheast Microsoft Excel Charting 1 5th Dec 2003 11:53 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:16 PM.