Help with Chart VBA

[mrhuman]

I have a chart with column stacked and line from a table of 60 columns and the 59th column alone is the line which cuts the columns something like the image shown. Problem is I have code like this

 ActiveChart.SeriesCollection(59).ChartType = xlLine
    ActiveChart.Axes(xlValue).MajorGridlines.Select

But if a column in the table is added or deleted I have to manually enter the column number for the line.
Can someone tell me how to make the chart dynamically understand to choose only the second last column for line chart.

 

[RickXL]

Hi,

ActiveChart.SeriesCollection.Count
[/code
Will tell you the total number of series. So:
[code]
ActiveChart.SeriesCollection(ActiveChart.SeriesCollection.Count-1).ChartType = xlLine

would be one way to do it.

I might try to make it easy for myself and always do that one first so it would always be number 1.

Regards,