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. |
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. |
All times are GMT +1. The time now is 03:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com