How to change Chart Line size?

[ThomasHaller]

Hello folks,

I can't seem to find a documented way to alter the line size (width/weight) using Excel VB.

Fort example here I am drawing a horizontal "High Alarm" line on my graph, and I would like to set the line size (width/weight).

ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(HighAlarmSeriesNum).Border.Color = RGB(255, 0, 0)
ActiveChart.SeriesCollection(HighAlarmSeriesNum).Name = "='Cond Graphs'!$C$4"

I tried

ActiveChart.SeriesCollection(HighAlarmSeriesNum).Size = 1.5

But just got my favorite 1004 error...

- Thomas