Hi,

I have a question regarding changing the line styles in a graph with a
macro.

There are several series in the graph, however, they are named either
"SOT_*" or "EOT_*" . * being the rest of the series name.

Currently, all of the lines are solid. But I wish to change all the
series with the prefix EOT to dashed and leave the others as they are.

How do I create a macro loop code that looks for the prefix of the
series' name and change the line style based on the prefix?

Thanks a bunch!


--
trumptmast
------------------------------------------------------------------------
trumptmast's Profile: http://www.excelforum.com/member.php...o&userid=34305
View this thread: http://www.excelforum.com/showthread...hreadid=570058