Excel 2007 Chart title problem

[skoley]

Hi All,

I am working with an application(with VB.Net) which generates Excels dynamically.
Excel sheets contain Excel Chart and the Chart has the following :
a) Chart Title
b) Legend
c) X-axis title
d) Y-axis title

Problem :
Y-axis title in some cases should contain subscripted text. For example if the Y-axis title is "Cmax (mg/L)" , "max" will be displayed as subscripted and the rest should be normal text. But I am not able to do this with Vb.net code

Note : The problem is occuring only in case of Chart objects.

Code that I am using in VB.net with XP OS :
Dim SubscriptCharacters As Excel.Characters = MyAxis.AxisTitle.Characters(SubscriptStart + 1, SubscriptStop - SubscriptStart)

SubscriptCharacters.Font.Subscript = True

here, by SubscriptCharacters I am retrieving the substring(for example "max") that needs to be subscripted.



Question :
How to resolve the issue in Excel 2007 issue. Please can any one help me ?