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
Bookmarks