0

Hi

I created an DB, that export data to Excel and create a chart from this data, now I want to know, what can I do to filter data and set a criteria eg. A$2:D$46-range, Criteria =2.

The filter is not working if I set that critria, for the data in the cells are pulled from Access ,please help

2
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by rlangev
0

I created a excel sheet that pulls the data from access, now I want to create a chart in excel to filter specific info in the excel sheet. It's not giving me the result i want.

0

Charts don't filter data. Charts graphically display data. You need to filter the data before making the chart. So essentially you need to use possible either Advanced filter or auto filter within Excel to get the data to look a specific way before creating your chart.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.