Line charts line weights

[jhall01]

Ok, this i may sound stupid, but how can i increase the weight of all the lines on a chart at the same time.

I have several line charts tracking 10 different categories and all I want to do is change the weight of the line to be thicker.

Currently i have to select each one individually...am i just clueless or is it not possible?

Thanks,

Jon

 

[SkipVought]

Hi,

Is this an embedded chart or a chart sheet?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[AndyPope]

Hi Jon,

The quickest way without code is to select one of the lines and change the weight. After you have closed the dialog use the up/down cursor keys to move through the other line series at each one use the F4 key to apply the previous change.

I don't believe there is a way of selecting multiple data series and applying a change.

Cheers
Andy

 

[jhall01]

How bout code I am assuming VBA and I semi-proficient at some VBA?

It is embedded not a chart sheet

 

[SkipVought]

That's why I asked....

Is this an embedded chart or a chart sheet?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884