Sets the title text and the title font of the x- and y-axes.

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 worksheet.
Note The Excel Set Graph Font VI only sets the font on graphs you create using the LabVIEW Report Generation Toolkit for Microsoft Office. The VI does not set the font on graphs you create in Excel manually.


icon

Inputs/Outputs

  • cstr.png number format (general) —

    number format describes the format to apply to the axis of the graph.

    Refer to the Microsoft Excel documentation for more information about number formatting.

  • ccclst.png axis font —

    axis font sets the font attributes of the axis tick labels and legend.

  • cstr.png font style —

    font style specifies a specific Microsoft Word style to apply to the text.

  • cbool.png bold —

    bold specifies whether the text is in bold.

  • cbool.png italic —

    italic specifies whether the text is in italics.

  • cbool.png underline —

    underline specifies whether the text is underlined.

  • csgl.png size —

    size specifies the point size of the font.

  • cu32.png color —

    color specifies the text color. The default is black.

  • 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.

  • cstr.png title ("") —

    title contains the axis title.

  • 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.