Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 Lori Sloane wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Ho do I make multiple line within a cell? | Excel Discussion (Misc queries) | |||
Multiple Plot Shading in Line Graphs | Charts and Charting in Excel | |||
gap width zero - double line | Charts and Charting in Excel |