Change chart source data to variable value

[ankita.sethi]

Hi,

I am trying to change a chart data source to some values of variable that have been calculated in VBA itself, but I am failing to do so

The variable names that I have calculated are a, b, c, and ot

I tried doing this:
'change the chart numbers
Sheets("Sheet1").ChartObjects("Chart 3").Activate
ActiveChart.SeriesCollection(1).Values = (a,b,c)
ActiveChart.SeriesCollection(1).Name = "=""ser1"""

However, there is a syntax error in this macro where the text is red.

Can anyone please help me with this?

Regards,
Ankita

 

[Andrew Poulsom]

The Values property expects a formula as a string. Example:

Sub Test()
    Const a As Long = 10
    Const b As Long = 20
    Const c As Long = 30
    ActiveChart.SeriesCollection(1).Values = "={" & a & "," & b & "," & c & "}"
End Sub

 

[ankita.sethi]

Thanks a ton!!! This was posing a big problem for me!!