View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Input a Value to Lookup the Data Series for a Chart

When you click the filter dropdown, select Custom and in the dialog box
select Equals and insert the Symbol in the field (Note for the same reason of
1000 limit you can't use the drop down to insert the symbol in the field but
you can type or copy it in).

Alternatively.
What sort of 'Symbols' are you using? Can they be divided up into groups of
up to or less 1000? If so, then you can use the following method:-

Insert an additional column.
Place a grouping character (or characters) in it to identify each group.

then

Select the group filter first.
Select the Symbol filter next.


--
Regards,

OssieMac