Count Legend entries?
Count Legend entries?
(OP)
Hi there, anyone know of a way of counting the number of entries (the elements in the legend) in an embedded chart (one that's not on it's own sheet)?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Count Legend entries?
LegendNos=ActiveChart.Legend.LegendEntries.Count
LegendNos can have a value <= the no. of series in the chart.
Deleted legend entries are excluded from the count.
RE: Count Legend entries?