line weight in line charts

[Guest]

Hi
Iam wondering if somebody can help to make the lines in the line chart the thickest (weight) by default . Instead of setting afte
I create the chart. Apparently I don't see any such option under tools->options->....
Any ideas would be greatly appreciated
thanks in advanc
Kanan

 

[Nicky]

Hi

You can create a chart with the formats you want and save it as
user-defined chart. Also, you can set this as your default chart, i
you like.

I think the exact process depends a bit on which Excel version yo
have, but if you activate the chart you want to save, it will b
something like:

chart, chart type, custom types, user-defined, add...

to create your chart type, and

click 'set as default' to make all new charts in this style.

or, you could run this short macro:

Sub lines_width_thick()
For Each ss In ActiveChart.SeriesCollection
If ss.ChartType = xlLineMarkers Then ss.Border.Weight = xlThick
Next
End Su

 

[Guest]

thanks. that was a great idea
kanan