I am trying to control the marker properties in an excel chart, with each point in a single series taking on different properties. However, it is choosing to ignore most of the settings that I tell it to use. For example, I have a scatter chart with a single point plotted on it. Using the following code snippet, I can change color and size of the marker, but the style will not change. When I query the proerties of the individual point, either through vba or the excel format window, it shows all values at automatic (as opposed to what I set, and what I see on the chart). Why will the style not change to circle, and why do the property queries not match what I see or set?
very frustrated and confused....
For Each bubble In Charts(1).SeriesCollection(1).Points
.MarkerStyle = 8
.MarkerForegroundColor = RGB(0, 0, 0)
.MarkerBackgroundColorIndex = 8
.MarkerSize = 52