Expression count in macro

[#1]

I'm writing a macro to toggle showing or hiding values on data points. It works for a chart with a single expression using

Expressions.Item(0), but I'd like to use it for charts with multiple expressions. In my macro, how can I get a count of how many expressions are in my chart so I can cycle through them with a FOR clause?

[zhadrakas]

Hello Len,

set chart = ActiveDocument.GetSheetObject("CH21")
set cp = chart.GetProperties
n = cp.Expressions.Count

[Anil_Babu_Samineni]

Macros Are not Good Tim.

Len, Yes we can show. Please find attachment for Ref. Hope this helps

[#4]

Thanks, that worked. The Expressions.count was what I needed.

[zhadrakas]

good to know. please dont Forget to mark this as answered.