Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 960 | Replies: 4 | Solved
 |
•
•
Join Date: Apr 2008
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
$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
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
$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
•
•
Join Date: Mar 2006
Location: Japan
Posts: 156
Reputation:
Rep Power: 3
Solved Threads: 17
Junior Poster
What exactly do you want to filter? The data in Excel or Access?
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
•
•
Join Date: Apr 2008
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
•
•
Join Date: Mar 2006
Location: Japan
Posts: 156
Reputation:
Rep Power: 3
Solved Threads: 17
Junior Poster
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.
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
