I am actually doing this from Access but in order to simply and try to isolate the issue I have put it into a simple macro in excel.
I have a chart on a worksheet on which I want to re-format the default format of the series line & markers. If I right click on the series line interactively and select "Format Data Series", select "Shadow" the select a "Preset" shadow, it applies the shadow to the Marker 'which is exactly what I want.
However, when I try to do this from VBA, it applies the shadow formatting to the lines that join the markers rather than the markers themselvs. Funny thing is, I cant actually find a way to do apply shadows to the lines interactively, not that I want to.
My code is below and I have documented it as much as I can to explain what I am doing and an alternative that I have tried. If anyone can figure out how to get the shadow affects to work on the Markers rather than the lines through VBA it would be much appreciated.
'=================================================================
Any help is appreciated,
Cheers
Bookmarks