•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 391,984 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,207 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 771 | 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: 129
Reputation:
Rep Power: 3
Solved Threads: 12
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: 129
Reputation:
Rep Power: 3
Solved Threads: 12
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)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
Similar Threads
- Writing to an Access Database (Visual Basic 4 / 5 / 6)
- VB: Connect to Access database via ODBC datasource name (Visual Basic 4 / 5 / 6)
- Disable access to .htaccess (Linux Servers and Apache)
- Writing to an Access Database using Java... (Java)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Database Authentication
- Next Thread: Switchboard
