There are two answers. 1. The VBA way --- Create an Excel template with the charts and or graphs you require based off your data. You will need to copy some of this over to a workbook while you create the charts. Then write VBA to open the template, and store all the data you need for the report into the workbook. The graphs and charts will automatically update.
2. The simple way --- Write a query in Access to select the data you want. Create an Excel workbook, similar to above, but instead of VBA use Excel to bring in the data. Excel has an import menu option under "Data - Import/Export". You can create a new Excel query, which is a wizard that will step you through the process of linking to your Access query. When this is complete you can refresh the Excel data from within Excel at any time, thus updating the graphs. Side Note: Step 1 can also be done in reverse, meaning that you can use Excel VBA to call the Access query and bring in the data. Either way, it helps if you are an experienced VBA user to accomplish step 1, else I recommend working with step 2. Craig Gross Sales Reporting Analyst/VBA-Developer Baker & Taylor 908-541-7197 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of yogesh9548 Sent: Monday, June 25, 2007 4:13 AM To: [email protected] Subject: [Access VBA Central] Charts and Graphs in Access Hi, I have an access database where in we have a table which contains a daywise report. What I would be needing is to create a graphical presentation for the data stored in the table. Can someone help me in how to proceed with this requirement? Yahoo! Groups Links This email and any attachments contain information from Baker & Taylor which may be confidential, privileged and/or protected by other legal rules. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or use of the contents of this email is prohibited. If you have received the email in error, please notify us by reply email immediately and then delete the email and your reply from your email system. NOTE: Baker & Taylor accepts no liability for the contents of this email. This email shall not operate to bind Baker & Taylor to any contract, order or other obligation.
