Chart Title SuperScript

[Bill]

Hello,
I have a chart title with only one character that I want to make superscript
using VBA Code. For example:

"This is my number R2 today"

I want the 2 to be superscript. Is there a way to do that?

Thanks.

Bill

 

[Guest]

It is a mouthful, but:
Worksheets("Sheet1").ChartObjects(1).Chart.ChartTitle.Characters(20,1).Font.Superscript = True

 

[Bill]

Thanks. That worked.

Bill

It is a mouthful, but:

Worksheets("Sheet1").ChartObjects(1).Chart.ChartTitle.Characters(20,1).Font.
Superscript = True