Need help modifying Excel Macro Example.vi

[SS_01]

I have a working VI using Excel Macro Example.vi to create a chart in Excel from the data in my VI. My problem is that I need to create a header from data entered on the front panel of the VI. I cant see how to modify the example VI to read in a header.

[Alberto]

Hi,
if you need to insert a header on data column you can use the property Range as shown in the vi. See example modified: a header is added to the columns at row 1.
Note that for a correct graph visualization you should modify the macro script to set the new data range.
Hope it helps,
Alberto

[SS_01]

Thanks, but how do I put header into the chart rather than the data?
Also, would you mind saving your files for LV 6.0, as I cant open the file you sent me.

Thanks again

[Michael_Munroe]

You can implement the header directly into the macro very easily. Just pass the string Title to the macro as ARG1. Then change the following two lines in the macro:

Old: Sub GraphData( )
New: Sub GraphData(NewTitle As String)

Old: .ChartTitle.Characters.Text = "Data"
New: .ChartTitle.Characters.Text = NewTitle

Save the changes in your project.xls file and you are good to go.

Michael
www.abcdefirm.com

[Alberto]

Hi again,
here is the example in LV6.
To place the header on the chart follow Michael's answer.
Alberto

[SS_01]

Thanks, that works great!