Conditional Formatting for Charts

Hi all,

I have created an automatic data sorting spread sheet that sorts a long list of data into daily profiles and then groups them based on business day/non-business day. The first reading date/time can be altered and then the whole spread sheet updates to suit. This part seems to be working well.

I now wish to set up 12 charts (one for each month of the year) and I want the line style to automatically update so that business days are differentiated from non-business days (for example dotted line for NBD and solid line for BD). I also want the chart tab name to automatically update and the chart title to update automatically to incorporate the dates.

I have little experience with VBA.

I have attached the spread sheet I am working on.

Much appreciated in advance.