how do I weight many lines at once in a graph?
 

I want to use scatter plot with lines and the default is thin light weight
lines. I want to change all lines to heavy weight thickness without
formating each series. There are many series.

how do I weight many lines at once in a graph?
 

Hi,

You can not apply formatting to ALL series at once.
The best you can do is to format the first series and then use the up
arrow key to move through the series and press F4 to repeat the
formatting as each series is selected.

Cheers
Andy

Mr. Owl wrote:
I want to use scatter plot with lines and the default is thin light weight
lines. I want to change all lines to heavy weight thickness without
formating each series. There are many series.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

how do I weight many lines at once in a graph?
 

Andy,

Well that's really cool!! I didn't know the F4 trick and I'll explore its
use more now. That procedure is just fine for me. Thank you very much

Owl

"Andy Pope" wrote:

Hi,

You can not apply formatting to ALL series at once.
The best you can do is to format the first series and then use the up
arrow key to move through the series and press F4 to repeat the
formatting as each series is selected.

Cheers
Andy

Mr. Owl wrote:
I want to use scatter plot with lines and the default is thin light weight
lines. I want to change all lines to heavy weight thickness without
formating each series. There are many series.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

how do I weight many lines at once in a graph?
 

Hi Owl,

I did it 3 weeks ago for 60 lines plot, but don't have the VBA code at
home. Basically you can get the total count of the series within the
graph and within a loop apply the appropriate weigth to each line (it
is a specific command)
Can send you the code as soon as I get back to work next week.

Best regards
Philippe

Andy,

Well that's really cool!! I didn't know the F4 trick and I'll explore its
use more now. That procedure is just fine for me. Thank you very much

Owl

"Andy Pope" wrote:

Hi,

You can not apply formatting to ALL series at once.
The best you can do is to format the first series and then use the up
arrow key to move through the series and press F4 to repeat the
formatting as each series is selected.

Cheers
Andy

Mr. Owl wrote:
I want to use scatter plot with lines and the default is thin light weight
lines. I want to change all lines to heavy weight thickness without
formating each series. There are many series.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

how do I weight many lines at once in a graph?
 

Philippe,

This is great support! Andy's F4 trick is easy enough for me. I do
occasionally use the macros, though I'm not good at it. If I have many
similar graphs to do, I'll get one formated and save it by all means. Then
copypaste/formats to get a whole series the way I want in the next graphs or
after I make changes in other graphs.

Thanks guys.

Owl

"Philippe" wrote:

Hi Owl,

I did it 3 weeks ago for 60 lines plot, but don't have the VBA code at
home. Basically you can get the total count of the series within the
graph and within a loop apply the appropriate weigth to each line (it
is a specific command)
Can send you the code as soon as I get back to work next week.

Best regards
Philippe

Andy,

Well that's really cool!! I didn't know the F4 trick and I'll explore its
use more now. That procedure is just fine for me. Thank you very much

Owl

"Andy Pope" wrote:

Hi,

You can not apply formatting to ALL series at once.
The best you can do is to format the first series and then use the up
arrow key to move through the series and press F4 to repeat the
formatting as each series is selected.

Cheers
Andy

Mr. Owl wrote:
I want to use scatter plot with lines and the default is thin light weight
lines. I want to change all lines to heavy weight thickness without
formating each series. There are many series.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info