Can I associate excel marker style with series name?

[Marmot]

I have never used VBA programming but I have recently come to use Excel 2007 and found that a lot of the old Ecel 2003 operations or are no longer available or require a lot more "clicks" to get what I need. Anyway, because of this I have found myself stumbling into Macros and I have found that they can do some very handy things that i wasnt aware of.

Firstly, I have found that I can associate series colours (lines and markers) with cell colours using the code below (modified version of something taken from peltiertech.com). I am using xy scatter graphs with a line and this neatly changes all markers and lines to the cell colour defined on sheet "colour" where the range A1:A3 is the list of series used and each cell has been filled to the desired colour. It also changes all markers to squares.

What I would like is for each of the three data series to have an individual marker style. Can anyone help with this? For example my 3 data series are: Clay, Sand and Silt. i would like the Clay=triangle, Sand = sqaure and Silt=circle (or something similar).

I have a lot of graphs, plotting different data sets for the same three series and it would save me time if I could run a macro that resulted in the points and lines for Clay (for example) to always be the same.

Many thanks for your help

Please Login or Register  to view this content.

[Andy Pope]

If you use the same 3 data sets, in the same order, for lots of chart then maybe you could set up a chart template.

For the code you can test series name

Please Login or Register  to view this content.

[Marmot]

Andy

Many thanks for that, your script worked perfectly.

I should have thought about using a template but at the moment the data series are not always in the same order so might not work as neatly as I would hoped.

Thanks for your help