Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Help with pivot charts and data labels | Charts and Charting in Excel |