Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do I make multiple line width changes for a spagetti plot?

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default How do I make multiple line width changes for a spagetti plot?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Line Width in Line or Scatter Chart Marvin Charts and Charting in Excel 2 February 10th 07 05:44 PM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM
Ho do I make multiple line within a cell? Maria13 Excel Discussion (Misc queries) 2 July 6th 06 11:24 PM
Multiple Plot Shading in Line Graphs ask72883 Charts and Charting in Excel 1 May 15th 06 07:28 PM
gap width zero - double line Jan Charts and Charting in Excel 3 March 28th 06 11:30 PM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"