Sorry, it took me long to send you a reply.

What I'm doing is Data Validation as my criteria when generating data.

Let's say: US, UK, ANZ, and IND are my choices in the Data Validation. If I choose US, the graph below would only show the data for US. However, a question was raised to me if there is a way I they could see one graph containing ANZ and IND as the criteria. And that's not possible with Data Validation.

Is there any other way to do it aside from Pivot? My raw data is updated regularly.

THanks again,
rekussu