ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change color of points of scatter plot (https://www.excelbanter.com/excel-programming/430815-change-color-points-scatter-plot.html)

John[_142_]

Change color of points of scatter plot
 
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.co lorindex

That works for bar charts, but not scatter plots.

Thanks,
John

Lars-Åke Aspelin[_2_]

Change color of points of scatter plot
 
On Tue, 7 Jul 2009 13:11:34 -0700 (PDT), John
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.c olorindex

That works for bar charts, but not scatter plots.

Thanks,
John



Try this

ActiveChart.SeriesCollection(1).MarkerBackgroundCo lorIndex

Hope this helps / Lars-Åke


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com