Formatting Graphs in Reports (Report Generation Toolkit)

LabVIEW 2013 Report Generation Toolkit for Microsoft Office Help

Edition Date: June 2013

Part Number: 370274G-01

»View Product Info

The Excel Graphs and Pictures VIs and the Word Graphs and Pictures VIs in the LabVIEW Report Generation Toolkit for Microsoft Office provide an interface to the graphing capabilities of Microsoft Office.

When you insert graphs into reports, you must send data to the graph as a 2D array of numbers. You can send row and column headers, or values and categories, as 1D arrays of strings. Graphs can hold up to 4,000 rows and 4,000 columns including row and column headers, and they can display up to 256 data series.

Graphs and images form a collection for each Microsoft Word document or Microsoft Excel worksheet. Each object in a collection has an index value based on the order of the objects in the document or worksheet. Index values begin at 0. The indexes for graphs and images are separate. For example, if an Excel report contains an image, a second image, and a graph, the index value for the graph is 0 because the graph is the first graph in the report.

Enter index values in the graph index or picture index inputs of the Graphs and Pictures VIs to specify which graph or image you want the VI to format. By default, Graphs and Pictures VIs apply to the last object in a collection of a document or worksheet. You can avoid confusion with collection index values by formatting graphs and images immediately after you insert them into a report.

The Graphs and Pictures VIs support all graph types that Microsoft Office uses. If you want to format a graph in a way that the Graphs and Pictures VIs do not support, insert the graph in a Word or Excel template, format the graph, and use the Word Update Graph VI or the Excel Update Graph VI to fill the graph with data.

Refer to the MSGraph Reports.llb in the labview\examples\office directory for examples of inserting and formatting graphs in Word and Excel reports.


Not Helpful