How do I make multiple line width changes for a spagetti plot?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make multiple line width changes for a spagetti plots? I can go
into each line and change the weight individually, by right clicking "Format
Data Series" and under Pattern, select a thicker weight for the line. Is
there a way do this without selecting each of my 30 lines one at a time?
 
Hi,

There is not way of making the change to all the series at once.
You can make the change and then select the next series and use the F4
button to repeat formatting changes.

Another alternative is to use VBA code to make the changes

Select the chart. Go to the immediate window in the VBE. (ALT+F11 and
then CTRL+G)
Enter the following line and press enter.

for each X in _
activechart.SeriesCollection:x.Border.Weight = xlThick:next x

Cheers
Andy
 
Back
Top