|
 Excel VBA Macro to generate Chart |
| Posted by Anand on Mar-19-2022 18:42 |
|
Hi Peter,
I am using demo version of ChartDirector (COM/VB..) to plot some charts in Excel.
I have a macro which will plot chart on a Sheet. Eveything is working fine except, not able to get the tooltip. Following is the piece of code
Set chrt = Worksheets("Sheet1").OLEObjects("ChartViewer1").Objec
Set chrt.Picture = c.makePicture()
'include tool tip for the chart
'ERROR in the below line.
Set chrt.ImageMap = c.getHTMLImageMap("clickable", "", "title='[{dataSetName}] {xLabel}: {value}'")
"Object doesn't support this property of method" is the error message, on the last line.
Regards |
| Re: Excel VBA Macro to generate Chart |
| Posted by Anand on Mar-20-2022 01:12 |
|
HI Peter,
Instead of Macro, if I place this code, say in, WoekShert_Activate(), it runs smoothly.
Regards |
|
Forum Home
Search
Message List
Post Message