Sure, it's possible. But do you really need two charts. If you have one chart and a listbox for the Type field then you can easily use that one table to show Kids or Adults or both. Just select the types you want to see in the listbox.
If you do want two tables then it's probably easiest to create one or two alternate states (on the General tab of the Document Properties window) and assign the alternate state(s) to the relevant table. You can then select the type in the table. Selections in one alternate state won't have effect on objects in another state.
Peter, You can split your source table into no of small table like you want. But the only probelm is you may end up with synthetic keys or circular loops if you ahve other dimension tables keep only one table. It better keep into one table and create the flags on your table to differentiate the data granularity type.