Function to determine Chart Type

[sunny_talwar]

Hi Team -

Has anyone come across a function to determine which chart type we are on? Something like =ChartType('Object ID')

Best,

Sunny

[Kushal_Chawda]

Yes. Got it

[Gabriel]

Hi Sunny,

I have not tried this code before, but it looks like what you need. Hope it helps

rem ** get unique object ID for first object on sheet Main **

set s = ActiveDocument.Sheets("Main") // You can possibly have a variable to determine activesheet name

set so = s.SheetObjects(0)

id = so.GetObjectId

msgbox("ID = " & id)

[sunny_talwar]

Would you be able to share the sample here?