ActiveX excel chart title

[analog]

how do I add ActiveX Excel chart titles without using the Chartwizard method?

[Zvezdana S.]

analog,
As far as I know, the ChartWizard method is the only Chart method that has Title input.
Creating a Microsoft Excel Worksheet and Chart
Zvezdana S.

[Michael_Munroe]

Just add the Title to the chart after you run the ChartWizard. You will need to create a new reference to the chart using an index or name. The title must also be enabled first.

Wire WorkSheet to Method ChartObjects, wire index to 1
Use Variant to Data to convert to Excel.Chart
Wire into Property HasTitle, set to write TRUE
Wire Chart into Property ChartTitle
Cascade into Property Text, write the string here.

Michael Munroe
www.abcdefirm.com