Home > Archive > MS SQL Server OLAP > March 2006 > Re: Excel OLAP - turning off some of the Legend Entries









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Excel OLAP - turning off some of the Legend Entries
Mel Suarez

2006-03-27, 1:34 pm

Figured out how to delete...

Here's what I came up with to delete legends 6 thru 10:
Sub macroListLegendEntri
es()
Dim i
i = 6
Do While i <= ActiveChart.Legend.LegendEntries.Count
'MsgBox ("Deleting " & i)
ActiveChart.Legend.LegendEntries(i).Delete
Loop
End Sub

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com