Change color of points of scatter plot

J

John

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
 
L

Lars-Åke Aspelin

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
Click to expand...


Try this

ActiveChart.SeriesCollection(1).MarkerBackgroundColorIndex

Hope this helps / Lars-Åke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regression through select points on a scatter plot. 3
Plotting a number of single point series on a scatter graph 2
Workable Scatter Plot Data Points 5
xy scatter chart, macro to fill shapes 1
How do I plot two curves on a single XY scatter chart? 1
Charts -- drawing arrows to points 2
Scatter Plot Question - adding straight lines 0
change color of column chart 2

Top