Skip to Content
Former Member
Apr 02, 2008 at 12:29 AM

Filter Component


Hello all,

I am new to Xcelsius and have just started exploring the features of the product. I was wondering if any of the forum members would be able to answer a question on Filter Menu Component of the product.

I have the following:


A1 B1 1

A1 B1 2

A1 B2 7

A1 B2 10

A2 B1 1

A2 B1 5

A3 B1 1


I am trying to plot a chart on column C for every combination of A and B using the filter menu option. I created the filter option on columns A and B and tried to store this subset of data into a different worksheet and then create a chart that plots on this subset of the data.

Now when I compiled the file and ran it, only the first instance of the combination seems to be plotting. All the further occurences of the filtered data are not plotting in the chart. Is this a known issue with the "filter" menu that it does not output more than one row of the filtered data? I would appreciate your help,