Question

how do we use a simpler filter on data​

Answer 1

Answer:

Create chart for all your data. Include sales, profits and expenses

Now, apply data filters to the source data range (menu > data > filter > auto filter, in excel 2007, use home ribbon > filter & sort button > filter)

Select the type of data you want to use in the chart by applying a data filter

Bingo, you have a dynamic chart that can be controlled using data filter settings.