If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Import Charts and data to Access
Hello
I have an excel sheet containing data and graphs(Charts) based on them. I want these data and graphs to be imported to Access. Data must be linked together with specific graph (chart). I dont mind if the graph (Chart) is imported as image. I want to have a combo box on the top of a form. When I select an option to appear the data with the specific graph(chart). How I can do that?? Is there any example similar on the internet to look at it?? Please help me! Thanks in advance |
#2
|
|||
|
|||
Import Charts and data to Access
Hi Kyriaki,
Speaking very generally...yes, it's possible to: - Link your Excel spreadsheets to an Access database, - Create a form in the db based on the linked table/spreadsheet, - Add a chart object to the form based on the linked table OR a query based on the linked table - Have the chart object change dynamically depending on what record is displayed in the form (and how...columnar, tabular, etc.), - OR Paste the Excel charts in the form as images such as .jpg. Of course, these will be static images. It's difficult for me to offer more specific advice since I don't know how your data are arranged in Excel, your comfort level with Access, or how you wish to display your data. I suggest you go to Access, link your spreadsheet (File | Get External Data | Link), build your form or report (NOTE: Access forms are mainly for data entry. If you plan to display or print data, use a Report.) using the FormWizard, switch to Design View, add a chart object (doesn't matter what kind at this stage), then double-click on the chart to open MS Graph. The Graph Help file (surprise!) has quite a bit of useful information to help you get started. Good luck, LeAnne Kyriaki wrote: Hello I have an excel sheet containing data and graphs(Charts) based on them. I want these data and graphs to be imported to Access. Data must be linked together with specific graph (chart). I dont mind if the graph (Chart) is imported as image. I want to have a combo box on the top of a form. When I select an option to appear the data with the specific graph(chart). How I can do that?? Is there any example similar on the internet to look at it?? Please help me! Thanks in advance |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Import Data Keeps asking for Password | Dominator | General Discussion | 0 | June 5th, 2005 11:25 PM |
Using Excel charts in Access 2003??? | PZStraube | General Discussion | 0 | March 1st, 2005 01:02 PM |
charts lose data | Steve | Powerpoint | 0 | January 28th, 2005 06:13 PM |
Format record bound charts in Access, data labels and colors | TRS_JC | General Discussion | 0 | January 28th, 2005 05:41 PM |
Can I import Excel charts into ACCESS for reporting? | Marjie | Setting Up & Running Reports | 0 | January 19th, 2005 06:31 PM |