how do we use a simpler filter on data
Answers
Answered by
2
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.
Similar questions