log scale with excel report generation

[L54]

Hello,

 I am tryig to plot a Bode graph in excel using the report generation toolkit. I am plotting an XY graph using the Excel Easy Graph vi, X being a 1D array of frequencies and Y a 1D array of either phase or magnitude (X and Y being put into a 2D array using the Build Array.

Naturally, I want to have the frequency (X) axis in logarithmic scale and I have tried the axis config input of Excel set Graph scale vi for this but it generates an error.

See attached code (the part that generates the error is currently disabled) and snapshot of error.

Thanks in advance for your help.

[RavensFan]

The charts show up in Excel as column charts, so a logarithmic X scale makes no sense for that.  If you try to format the axis on the charts that get created, you can see that a log scale is not an option.

Try changing the chart type to xlXYscatter.  It is set for xlLine, (which is a useless chart format in Excel because it looks like the XY chart that people would want, but it's not), but for whatever reason, the xlLine turns into a column chart.

By the way, you have some blank spaces at the beginning of some of the elements in your string array.

[L54]

 Thanks a lot, it works now.