Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
Change Box Line Weight - Excel 2007 | Excel Discussion (Misc queries) | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |