DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- MS Access and FileMaker Pro (http://www.daniweb.com/forums/forum128.html)

- - Access (http://www.daniweb.com/forums/thread121211.html)

rlangev

Apr 27th, 2008 7:51 am

Access

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

HI2Japan

May 1st, 2008 1:32 am

Re: Access

What exactly do you want to filter? The data in Excel or Access?

rlangev

May 7th, 2008 10:22 am

Re: 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.

HI2Japan

May 7th, 2008 6:32 pm

Re: Access

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.

rlangev

May 25th, 2008 8:17 am

Re: Access

Never mindd, thank you

All times are GMT -4. The time now is 3:55 am.