Sets the scale parameters of the x- and y-axes and formats the graph gridlines.

By default, the VI applies to the last graph you insert in the current worksheet. Use the graph index input to format a specific graph in the current worksheet.
Note The Excel Set Graph Scale VI only sets the scale on graphs you create using the LabVIEW Report Generation Toolkit for Microsoft Office. The VI does not set the scale on graphs you create in Excel manually.


icon

Inputs/Outputs

  • cNI__reportlvclass.png —

    report in is a reference to the report whose appearance, data, and printing you want to control. Use the New Report VI to generate this LabVIEW class object.

  • ci32.png axis type (xlCategory) —

    axis type specifies the type of axis to format.

    The default is xlCategory, which generally represents the X axis. You also can select xlValue, which generally represents the Y axis.

  • ci16.png graph index (-1) —

    graph index specifies the index of the graph to modify. The default is -1, in which the VI modifies the last graph in the current worksheet.

    Note Graphs, images, ActiveX controls, and OLE objects form a collection for each worksheet. Each object has an index value based on the order of the objects in the worksheet. Index values begin at 0. For example, if you insert two images into the worksheet before you insert a graph, the index value for the graph is 2.
  • cerrcodeclst.png error in (no error) —

    error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

  • ccclst.png axis config —

    axis config specifies the ways in which the VI scales the axis.

  • cbool.png autoscale —

    autoscale determines whether the VI scales the axis automatically. The default is TRUE, which enables autoscaling.

  • cdbl.png min —

    min specifies the minimum scale value if you set autoscale to FALSE.

  • cdbl.png max —

    max specifies the maximum scale value if you set autoscale to FALSE.

  • ci32.png scale type —

    scale type determines whether you want a logarithmic or linear scale. The default is linear.

  • ccclst.png gridlines —

    gridlines sets the gridlines parameters.

  • cbool.png has major gridlines? —

    has major gridlines? determines whether the graph includes major gridlines. The default is FALSE, in which the graph does not include major gridlines.

  • cbool.png has minor gridlines? —

    has minor gridlines? determines whether the graph includes minor gridlines. The default is FALSE, in which the graph does not include minor gridlines.

  • cu32.png major gridlines color —

    major gridlines color sets the color of the major gridlines in the graph. The default is black.

    You can wire a color box constant to this input.

  • cu32.png minor gridlines color —

    minor gridlines color sets the color of the minor gridlines in the graph. The default is black.

    You can wire a color box constant to this input.

  • iNI__reportlvclass.png —

    report out is a reference to the report whose appearance, data, and printing you want to control.

    You can wire this output to other Report Generation VIs.

  • ierrcodeclst.png error out —

    error out contains error information. This output provides standard error out functionality.