[RESOLVED] Chart lines and position.

[yorch]

Hi all,
1. How do I modify the lines in a chart (series lines)?, I have search for info but nothing found.

2. When I create a chart, I can only play with its position in pixels. Do you know a way to handle it with the cells position?

thanks!!, Yorch

[zaza]

1) use the SeriesCollection properties of the Chart object.

Top tip. Record a macro in which you do something to a chart. That will give you all the code you need.

[yorch]

Thanks!. But, could you please give an example because I have tried to do it but help file does not give more instructions, i have tried:

With Sheets("Symptom Search Result").ChartObjects.Add(32, 50, iSympY * 15, 280).Chart
.SeriesCollection.Add Sheets("Symptom Search Result").Range("B28" & (iSympY - 1))
.ChartType = xlColumnStacked100
.HasTitle = True
.ChartTitle.Text = "Server Comparative Graph - Symptoms"
.SeriesCollection(1).Line.Width = 500 ' or
.SeriesCollection(1).Lines.Width = 500
End With

Kind Regards,

[yorch]

Thanks, I continues playing and found the solution.

With Sheets("Sheet1").ChartObjects.Add 1,1,5,5).Chart
.SeriesCollection.Add Sheets("Sheet1").Range("B4:C15")
.ChartType = xlLine
.HasTitle = True
.ChartTitle.Text = "Server Comparative Graph"
For y = 1 To 3
.SeriesCollection(y).Border.Weight = xlMedium
Next
End With

Yorch