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
Jump to PostWhat exactly do you want to filter? The data in Excel or Access?
What exactly do you want to filter? The data in Excel or Access?
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.
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.
Never mindd, thank you
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.