Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 20
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 20
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connected from Excel to Access Damil4real Excel Discussion (Misc queries) 3 September 15th 08 06:10 PM
Excel Pivot Table connected to an Access Database Data Source Alex Zimmerhaven Excel Discussion (Misc queries) 2 June 10th 08 03:04 AM
line chart base to a pivot chart rahmad[_2_] Charts and Charting in Excel 0 March 23rd 07 01:43 PM
Access data base is able to store any number of records clearcell Excel Worksheet Functions 0 November 8th 05 09:45 PM
HOW TO HIGHLIGHT DATA CONNECTED TO A HYPERLINK IN EXCEL toni Excel Discussion (Misc queries) 0 July 21st 05 11:06 AM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"