Good morning everyone,

I have created a couple of simple line charts that change the data they display based upon a user selection. This means that in my example users can choose to view either Phone or Web performance. I already have the code that changes the charts data source based upon the selection but whenever it changes it reformats to the standard look of the line chart. It may sound picky but i have standard formatting across all the reporting i produce and this is not what i want. Im happy to go with the standard colours that excel is selecting but want to make all of the lines thicker and remove the markers on all of the data series. Is there some way of doing this is code or am i going to have to live with it and hate the look of my report ?

Hopefully that has adequately explained my problem if not please let me know and ill give more detail.

Thanks

EddiesVoicebox