Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart connected to an Access data base
Hi guys,
I have a worksheet with data connected to a Access Data base, 3 columns in total, one column with different dates (D/M/Y) and the other 2 with quantities; I want to create a Line chart with this data to compare quantity-1 and quatity-2, the problem is that the data is very detail, in days and I want to create a chart to compare the quantities but monthly, I could aggregate the data manually but since the data is coming from a database, is going to be updated daily, I want to create something more automatic. Second, I was talk that Microsoft Access doesnt have a tool to create charts, is that right. Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart connected to an Access data base
Hi,
First let me deal with the second question - you were told incorrectly, Access does have a charting capability. You can add charts to Forms, Reports or PivotTables. In the first two choose Insert, Chart while in design view. Where would I recommend you chart your data? - I prefer Excel. If this helps, please click the Yes button Cheers, Shane Devenshire "Maracay" wrote: Hi guys, I have a worksheet with data connected to a Access Data base, 3 columns in total, one column with different dates (D/M/Y) and the other 2 with quantities; I want to create a Line chart with this data to compare quantity-1 and quatity-2, the problem is that the data is very detail, in days and I want to create a chart to compare the quantities but monthly, I could aggregate the data manually but since the data is coming from a database, is going to be updated daily, I want to create something more automatic. Second, I was talk that Microsoft Access doesnt have a tool to create charts, is that right. Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart connected to an Access data base
Hi,
I've tested 2003, and if you build a chart from a data connection to Access, using Data, Import External Data, New Database Query, when the data refreshes the chart range adjusts. If this helps, please click the Yes button Cheers, Shane Devenshire "Maracay" wrote: Hi guys, I have a worksheet with data connected to a Access Data base, 3 columns in total, one column with different dates (D/M/Y) and the other 2 with quantities; I want to create a Line chart with this data to compare quantity-1 and quatity-2, the problem is that the data is very detail, in days and I want to create a chart to compare the quantities but monthly, I could aggregate the data manually but since the data is coming from a database, is going to be updated daily, I want to create something more automatic. Second, I was talk that Microsoft Access doesnt have a tool to create charts, is that right. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connected from Excel to Access | Excel Discussion (Misc queries) | |||
Excel Pivot Table connected to an Access Database Data Source | Excel Discussion (Misc queries) | |||
line chart base to a pivot chart | Charts and Charting in Excel | |||
Access data base is able to store any number of records | Excel Worksheet Functions | |||
HOW TO HIGHLIGHT DATA CONNECTED TO A HYPERLINK IN EXCEL | Excel Discussion (Misc queries) |