Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count Legend entries? 1

Status
Not open for further replies.
logius

logius

New member
Joined
Aug 23, 2001
Messages
13
Location
US
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)?
 
Sort by date Sort by votes
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
P.S. Of course, the chart must be activated before you can use the VBA code.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smma
  • Locked
  • Question Question
Progress Bar count lines of code
Replies
4
Views
267
joerd
joerd
hbejo
  • Locked
  • Question Question
Update entries from 2 different files
Replies
1
Views
145
msmith
msmith
shkim2000
  • Locked
  • Question Question
Counting blocks in autocad files
Replies
1
Views
170
gogogadgetscott
gogogadgetscott
logius
  • Locked
  • Question Question
Macro to Rewrite Legend Lables
Replies
5
Views
243
Mala
Mala

Part and Inventory Search

Sponsor

Back
Top