Modify Excel Chart Series Name Using ActiveX in LabVIEW

Updated Jul 11, 2019

Reported In

Software

  • LabVIEW

Other

Microsoft Excel

Issue Details

I am using ActiveX to to create charts in Excel, how do I change my plot's "Series Name" within LabVIEW? 

Solution

You must make use of several of the ActiveX property nodes in series for Excel to access the Series.Name property. Please see the attached VI and the screenshot below for one example on how this can be done.

Note: This image is a LabVIEW snippet, which includes LabVIEW code that you can reuse in your project. To use a snippet, right-click the image, save it to your computer, and drag the file onto your LabVIEW diagram.

Additional Information

You can also use Excel Function Syntax to specify a cell data for naming the Series name.
The example below extract the string in Cell A16 of the active sheet and writes that value as the Series name.

Attachments

ActiveX_excel_Series_name.vi

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.