Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2010, 06:23 AM
skoley skoley is offline Excel 2007 Chart title problem Windows XP Excel 2007 Chart title problem Office 2007
Novice
Excel 2007 Chart title problem
 
Join Date: Jul 2010
Posts: 1
skoley is on a distinguished road
Default 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
Reply With Quote
Reply

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
Excel 2007 Chart title problem 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
Excel 2007 Chart title problem Gantt Chart: MS Project vs. Excel Nance Project 2 12-09-2008 01:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft