| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i get lines on a line graph? | Charts and Charting in Excel | |||
| How do i get lines on a line graph? | Charts and Charting in Excel | |||
| Line Graph with 2 lines | Charts and Charting in Excel | |||
| Several (x, y) coordinated lines on one graph | Charts and Charting in Excel | |||
| Trying to plot two lines onto a single graph in excel | Excel Worksheet Functions | |||
Linear Mode
