Thread: Change color of points of scatter plot
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
  
Posts: 913
Default 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
Reply With QuoteReply With Quote