Problem with the number format in the graph axis with Report Generation Toolkit.

[Isa_pm]

Hi!

I'm trying to use the Report Generation Toolkit to plot some graphs in Excel.

My first problem is that I don't know how to configure the number format in the Excel Set Graph Font.vi so that my numbers are correctly displayed in the graph's axis. The only given option is general (0,0) but this is not enough for me, my numbers can get really small so I need engineering notation or fraccional format.

Second: I also insert a table with the graph source data, but the numbers are not correctly displayed either: for example: 

0,75 is shown as: 

0,750000

but 1,25  is shown as: 

1!250!000

My guess is I am making to much or wrong string to number conversions or Excel is getting it wrong but I can't find my way...

Can someone help me with this?

Thanks,

Isabel

[Isa_pm]

Here is my VI, it's just a trial so it can look messy...

Thanks,

Isabel

Message Edited by Isa_pm on 01-22-2007 01:12 PM

[jp_Braud]

Hi Isabel,

Your VI looks good. I think your trunkated datas are due to the office toolkit inner programming. Here is a KB that explain how to solve this.

http://digital.ni.com/public.nsf/websearch/BCA1ED356F6ABFF786256FF1007E1D1A?OpenDocument

Best Regards,