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

plot excel chart against datetime 0
Non Linear Scatter plot, need to find y value 3
Regression through select points on a scatter plot. 3
xy scatter chart, macro to fill shapes 1
Chart with a defined named range? 11
Arrays and scattered cell values or another way? 16
Plotting a number of single point series on a scatter graph 2
Trendline Not Appearing In Chart Problem ? 0

Top