#1
|
|||
|
|||
Excel 2007 Chart title problem
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 ? Last edited by skoley; 07-27-2010 at 06:29 AM. Reason: To add more information |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Updating Excel Chart Links | fermat | PowerPoint | 0 | 07-09-2010 04:29 PM |
Running total in Excel chart | jen152638 | Excel | 0 | 06-14-2010 05:38 AM |
Paste chart from Excel | bielak01 | Word | 4 | 04-29-2009 02:42 PM |
PP 2007: Template - Title slide boxes | netkos | PowerPoint | 0 | 02-19-2009 10:30 AM |
Gantt Chart: MS Project vs. Excel | Nance | Project | 2 | 12-09-2008 01:59 PM |