If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
change line formatting in line chart - Excel 2007
I have a user who has a chart with 40+ lines. He know how to change the
width of a line, but needs to do this with all the lines in this chart. Is there a way to change the thickness of all the lines in the chart at one time? This is a pivot chart in Excel 2007. Thank you. |
#2
|
|||
|
|||
change line formatting in line chart - Excel 2007
Hi,
Each series needs to be formatted individually. You code use code to speed things up. You might also be able to set up a chart template, not 100% sure the template get applied correctly to a pivot chart. You will need to format a chart with +40 lines change the line thickness and then save as template. You can then apply that template to other charts. This line of code in the immediate window will set the weight of all lines in the activechart. for i=1 to activechart.SeriesCollection.count:activechart.Ser iesCollection(i).format.line.weight=4.5:next i Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "LisaK" wrote in message ... I have a user who has a chart with 40+ lines. He know how to change the width of a line, but needs to do this with all the lines in this chart. Is there a way to change the thickness of all the lines in the chart at one time? This is a pivot chart in Excel 2007. Thank you. |
Thread Tools | |
Display Modes | |
|
|