Create excel chart from LotusScript, change xlLine line weight

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to adjust the line weight of an xlLine type chart from within
LotusScript. I cannot find any methods that control the line weight in VBA.
Everything I see concerning line weight deals with border, not the plotted
line. Any suggestions or help appreciated?
 
Roy,

In VBA, you change the series' Border.Weight to change the width of the
plotted line.

With ActiveSheet.ChartObjects("Chart
1").Chart.SeriesCollection(1).Border
.ColorIndex = 57
.Weight = xlThick
.LineStyle = xlContinuous
End With

You don't have much choice though: xlHairline, xlThin, xlMedium or xlThick.

HTH

Tim
 
Thank you, I will try this out and see if it works. Hopefully it will
translate to LotusScript somehow.

Roy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple charts in microsoft excel VBA macro 1
VB6 and Excel question 3
Excel hangs 1
Excel 2007 chart line width + axis labelling with VBA 6
Series order vs Legend Order in Charts 2
Find/Replace XLThin Line with XLHairline 2
Line & Column on Two Axes for Blood Pressure & Weight 3
Set the line weight with VBA in Excel 07 6

Back
Top