Can a chart title contain an integer variable or array index

[askinsb]

I am querying the worksheet and getting back the values I want and storing the values in an array.

Dim mynumbers(4) as Integer

I then want to update a chart title when the new numbers something like this.

Selection.Characters.Text = _
"Weekly Numbers" & Chr(10) & " mynumbers(1) " & Chr(10) &

How the chart title doesn't like any variable that are Integers and/or indexes in arrays that are Integers.

Any ideas? Can you convert Integers to string?

Brad

 

[Andrew Poulsom]

Re: Can a chart title contain an integer variable or array i

Maybe:

Selection.Characters.Text = _
"Weekly Numbers" & Chr(10) & CStr(mynumbers(1)) & Chr(10)

but I think the quotes surrounding mynumbers(1) is your main problem.

 

[askinsb]

Re: Can a chart title contain an integer variable or array i

Hey Andrew,

Thanks you were right on both accounts.

Here is the code that wound up working for me.

Selection.Characters.Text = _
"Confirmed By Severity" & Chr(10) & "P1 = " & CStr(mynumbers(1)) & Chr(10) & "P2 = " & CStr(mynumbers(2)) & Chr(10) & _
"P3 = " & CStr(mynumbers(3)) & Chr(10) & "P4 = " & CStr(mynumbers(4))

Thanks again.

Brad