Set the Axis Scale of Graph Data When Exported to Excel

Updated May 21, 2018

Reported In

Software

  • LabVIEW
  • LabVIEW Base
  • LabVIEW Full
  • LabVIEW Professional
  • LabVIEW Report Generation Toolkit

Issue Details

I use LabVIEW Report Generation Toolkit for exporting graph data to excel. Can I set the axis scale of graph data when it is exported to excel from LabVIEW?

Solution

If you have LabVIEW Report Generation Toolkit with LabVIEW, It is easy to set the axis scale of graph data when It is exported.

The function used in this way is Excel Set Graph Scale, which is on the Excel Graphs and Pictures Palette. The following screenshot shows the function.
 
Using axis type enumerated type controls, you can select which axis would be set. 'x|Category' represents the X axis and 'x|Value' represents the Y axis.

If you have done selecting the axis, enter the range of axis through axis config cluster, which contain the information about autoscale, min, max, scale type. Note that if the autoscale function in axis config cluster is true, the scale value can not be adjusted.

 

Additional Information

You can learn more about how to use LabVIEW Report Generation Toolkit at Creating a Report in Microsoft Excel Using the LabVIEW Report Generation Toolkit: Introduction.

WAS THIS ARTICLE HELPFUL?

Not Helpful