Macro Solid to dotted line

[jer3681]

Can somebody please help me to create a macro that makes my chart line dotted from today onwards?

I had a look at doing it the "usual" way without the macro but I need it to change automatically every day I open my spreadsheet.

I hope my rambling makes sense...

Thank you for your help

[Andy Pope]

What 'usual' way did you use?

You should be able to do this with formula nad multiple series

[jer3681]

The usual was using the multiple series. The problem I have with that is that I want it automaticalley to be dotted as of 'Today' rather than changing my data all the time...that's why I though a Macro would be more appropriate.