I have this bit of code:
Chart1.Chart.SetSourceData Source:=MC.Range(MC.Cells(1, 1), MC.Cells(100, nYrs+1))
Chart1.Chart.ChartType = xlLine
Chart1.Chart.PlotBy = xlRows
Chart1.Activate
It seems to default to x values from 1 to 31.
I want the x values to be 0 to 30.
Any slick ways to make that happen?
I tried playing around with some code that looks like this:
For Each objSeries In .SeriesCollection
objSeries.XValues = CStr(CInt(objSeries.XValues) - 1)
objSeries.Values = objSeries.Values
objSeries.Name = objSeries.Name
Next
But I get a type mismatch error.
Bookmarks