Chart Title SuperScript
 

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

Chart Title SuperScript
 

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

"Bill" wrote:

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

Chart Title SuperScript
 

Thanks. That worked.

Bill
"K Dales" wrote in message
...
It is a mouthful, but:

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

"Bill" wrote:

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