Hi,

I'm using a pivot table that shows data per date (past & future).

What macro can I write so that the past dates are represented by dotted lines and future dates by plain lines ?



Thanks for your help,

Rgds

Richard.