Excel Graph Axis Title

[charmand79]

Hi all,

Is there a way of naming the axes titles of an excel plot created using the Report Generation Toolkit? There does not seem to be such an option in the excel specific functions of the toolkit... Could it be done through activeX?? I tried to follow the suggestions in the link below but no luck...

http://forums.ni.com/t5/LabVIEW/labview-excel-2007-Axis-title/m-p/1226794/highlight/true#M521825 

Thanks a lot for your time..

Harry

[Yggr · Accepted solution]

Have you tried using "Excel set graph font" ? It should be possible to change x/y axis test with it

[charmand79]

Thanks a lot... Spot on.

[Beebrox]

I wonder, if one can do an example of this. I manage to get axis title for x axis, but cant acces to y... Help is not useful either.

[charmand79]

Hi,

I have attached a VI incl. many useful active-x commands for plotting graphs to excel. It is a large VI but it includes what you are looking for.. Scroll to the right and locate the 8th active-x box called chartwizard. This is what you are looking for. I have added constants indicating were the name of each axis goes in the wizard box. If you are not familiar with the rest of the active x commands just follow the sequence and you'l' be able to plot an excel graph fully customised through labview.

Hope it is of help

Harry