Change color of points of scatter plot

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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