noboffinme
Registered User.
- Local time
- Tomorrow, 02:46
- Joined
- Nov 28, 2007
- Messages
- 288
Hi
I have an Access database & an Excel Workbook.
I want toi do most of the reports I need in Access but would prefer to use Excel for the charts. I don't want to link the Access tables to Excel or have a copy of the tables in the Workbook.
I'd like to use a Formula as a Series for the Excel chart when the Chart is connected to the Access db.
So I'm connecting via ODBC & I want use something like;
for each series in the chart.
Does anyone have an answer for this? Thanks
I have an Access database & an Excel Workbook.
I want toi do most of the reports I need in Access but would prefer to use Excel for the charts. I don't want to link the Access tables to Excel or have a copy of the tables in the Workbook.
I'd like to use a Formula as a Series for the Excel chart when the Chart is connected to the Access db.
So I'm connecting via ODBC & I want use something like;
Code:
[FONT=Times New Roman][SIZE=3]=SERIES('Qtrly_Mastersheet_Rpt.accdb tbl'!$AM$1,'Qtrly_Mastersheet_Rpt.accdb [/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]tbl'!$A$2:$C$10,'Qtrly_Mastersheet_Rpt.accdb tbl'!$AM$2:$AM$10,36)[/SIZE][/FONT]
for each series in the chart.
Does anyone have an answer for this? Thanks