Aug 24, 2001 #1 logius New member Aug 23, 2001 13 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)?
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)?
Aug 24, 2001 1 #2 Mala Computer May 28, 2001 127 To count the number of legend entries, use 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. Upvote 0 Downvote
To count the number of legend entries, use 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.
Aug 24, 2001 #3 Mala Computer May 28, 2001 127 P.S. Of course, the chart must be activated before you can use the VBA code. Upvote 0 Downvote
