PC Review


Reply
Thread Tools Rate Thread

Change color of points of scatter plot

 
 
John
Guest
Posts: n/a
 
      7th Jul 2009
What is the object reference in XL07 to change the interior/fill color
of points in a scatter plot? I thought it was:

Activechart.seriescollection(1).points.interior.colorindex

That works for bar charts, but not scatter plots.

Thanks,
John
 
Reply With Quote
 
 
 
 
Lars-Åke Aspelin
Guest
Posts: n/a
 
      7th Jul 2009
On Tue, 7 Jul 2009 13:11:34 -0700 (PDT), John
<(E-Mail Removed)> wrote:

>What is the object reference in XL07 to change the interior/fill color
>of points in a scatter plot? I thought it was:
>
>Activechart.seriescollection(1).points.interior.colorindex
>
>That works for bar charts, but not scatter plots.
>
>Thanks,
>John



Try this

ActiveChart.SeriesCollection(1).MarkerBackgroundColorIndex

Hope this helps / Lars-Åke
 
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
offset scatter plot points Fish girl Microsoft Excel Charting 1 31st Jul 2009 08:15 PM
Regression through select points on a scatter plot. Tom Microsoft Excel Programming 3 10th Jun 2009 09:55 AM
Connecting Points In An XY-Scatter Plot Graph =?Utf-8?B?QWRhbSBXSw==?= Microsoft Excel Charting 2 9th Apr 2006 07:05 PM
Scatter plot points x and y coordinates =?Utf-8?B?TWlsbw==?= Microsoft Excel Charting 0 28th Nov 2005 11:24 PM
Too many points on xy scatter plot! Steve Microsoft Excel Charting 5 31st Dec 2003 11:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:41 PM.