Hi, I wonder whether someone could help me please.
I've put together the following script which applies a graph to a given sheet.
The problem I have is this line
.ChartType = xlLineMarkers
I'm trying to apply a line chart type to the first data series, but when I run the code, all of the data series are changed to line chart type. and I despite recording the macro, I'm not sure how to overcome this.
I just wondered whether someone may be able to look at this please and let me know where I'm going wrong.
Many thanks and kind regards
Chris
Bookmarks