change line formatting in line chart - Excel 2007

[LisaK]

I have a user who has a chart with 40+ lines. He know how to change the
width of a line, but needs to do this with all the lines in this chart. Is
there a way to change the thickness of all the lines in the chart at one
time? This is a pivot chart in Excel 2007. Thank you.

 

[Andy Pope]

Hi,

Each series needs to be formatted individually.
You code use code to speed things up.

You might also be able to set up a chart template, not 100% sure the
template get applied correctly to a pivot chart.
You will need to format a chart with +40 lines change the line thickness and
then save as template.
You can then apply that template to other charts.

This line of code in the immediate window will set the weight of all lines
in the activechart.

for i=1 to
activechart.SeriesCollection.count:activechart.SeriesCollection(i).format.line.weight=4.5:next
i

Cheers
Andy