how to change the Y-axis title orientation in excel chart with report generation tool kit

[BryanL]

HI, I need to change the Y axis title in an excel chart from horizontal to vertical while using report generation tools (RGT). Could anyone suggest a solution. I am a new user of the RGT, and I can plot a chart from a two column data, but the vi i used to change the chart scales didn't work. Also I would like to know how I pick different columns from a spread sheet to plot as x and y axis. your help is very appreciated.

[taoncl]

Hi BryanL

Can you please attach your code? It might be esier to deal with.

taoncl

[Philip_Courtois]

Hi Bryan,

What you are describing can be accomplished by using simple "Macro"s in Excel. Therefore you can simply start a small Macro that for example changes the Y axis title from horizontal to vertical alignment. After recording this Macro, you can run it from LabVIEW whenever you want. Please refer to the Shipping Example called "Run Macro on Word Table.vi" for a way to call the Macro (in this case Word, but it's similar for Excel).

Have fun!