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

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?
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing line weight in plot 1
Graph Line Width ? 1
For "Marker Line Style" see Point.Format.Line.Weight 2
multiple series bar and line chart 2
How do I plot a column average ? 1
How do i plot two series of data both in accending order on a line 1
Chart formatting 1
how do I weight many lines at once in a graph? 4

Top