Need help with macro to format a chart
 

Hi,

My pivot table chart is showing data for different dates (each field in the
legend is a date). How can I write a macro that will format the lines for
past dates as dotted lines and future dates as plain lines ?

Tks for your help