Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing trendline color and weight
I need to use VBA code to change the color and the thickness of trendlines in a chart I generated using VBA. For the life of me I cannot generate working code to change these trendline properties. Surely this can be done. If someone could help me out it would be greatly appreciated. -- biosci ------------------------------------------------------------------------ biosci's Profile: http://www.excelforum.com/member.php...o&userid=32827 View this thread: http://www.excelforum.com/showthread...hreadid=526311 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing trendline color and weight
Sub test()
Dim cht As Chart Dim sr As Series Dim tr As Trendline Set cht = ActiveSheet.ChartObjects(1).Chart Set sr = cht.SeriesCollection(1) Set tr = sr.Trendlines(1) tr.Border.ColorIndex = 3 tr.Border.LineStyle = xlDash 'xlContinuous tr.Border.Weight = xlThick ' xlThin End Sub Regards, Peter T "biosci" wrote in message ... I need to use VBA code to change the color and the thickness of trendlines in a chart I generated using VBA. For the life of me I cannot generate working code to change these trendline properties. Surely this can be done. If someone could help me out it would be greatly appreciated. -- biosci ------------------------------------------------------------------------ biosci's Profile: http://www.excelforum.com/member.php...o&userid=32827 View this thread: http://www.excelforum.com/showthread...hreadid=526311 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing trendline color and weight
Formating the trendline's border is what you're looking for I believe:
Sub Test() Dim cht As Chart Set cht = ActiveSheet.ChartObjects(1).Chart With cht.SeriesCollection(1).Trendlines(1).Border .ColorIndex = 3 .Weight = xlThin .LineStyle = xlContinuous End With End Sub Regards, Greg "biosci" wrote: I need to use VBA code to change the color and the thickness of trendlines in a chart I generated using VBA. For the life of me I cannot generate working code to change these trendline properties. Surely this can be done. If someone could help me out it would be greatly appreciated. -- biosci ------------------------------------------------------------------------ biosci's Profile: http://www.excelforum.com/member.php...o&userid=32827 View this thread: http://www.excelforum.com/showthread...hreadid=526311 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
different color on scatter plot separated by a trendline | Charts and Charting in Excel | |||
Changing line weight in plot | Charts and Charting in Excel | |||
Changing number precision of a trendline equation | Excel Programming | |||
how to create a multiple-color trendline in excel? | Charts and Charting in Excel | |||
changing font color and weight in comment boxes | Excel Programming |