how to put header and footer information in excel chart

[MM]

I modified the create chart.vi, I got from this site and able to create a chart from *.xls file. Now I want to print the filename as header and date and time the chart created as footer in the excel chart. Any idea is appreciated.

Thank you

MM

[Michael_Munroe]

Under the property node _Chart where you have the ChartTitle, add the property PageSetup. Cascade that into another property node and choose CenterHeader and CenterFooter. You can write the strings directly into these properties. Use the following codes:

Filename = &F, Date = &D, Time = &T

Be sure to close all references that do not leave the page (ie. Chart, Legend, ChartArea, etc.). Otherwise Excel will hang later on.

Michael Munroe
www.abcdefirm.com

[MM]

It works.

Thank you very much.