D
Dave Stone
I want to include in an Access report's detail section a chart (XY scatter)
which associates a custom error bar with the data series points (the size of
the bar is defined in another column of the base table on which the report
is based). This chart can be drawn in Excel but not, it seems, in Access due
to differences in the interfaces (if you know different, please get in
touch!).
If I must build the chart in Excel, can I incorporate it in my Access
report? If so, what's the best way -- push the chart from Excel using Access
as an automation server, or pull it from Access with Excel as the server?
Any useful books, websites, other refs. for this kind of stuff?
Thanks,
Dave
--
************************************************************************
Dave Stone e-mail: (e-mail address removed)
Computing Services Telephone: +44 131-650-3314
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: 0131-650-3308
Edinburgh EH8 9LJ
************************************************************************
which associates a custom error bar with the data series points (the size of
the bar is defined in another column of the base table on which the report
is based). This chart can be drawn in Excel but not, it seems, in Access due
to differences in the interfaces (if you know different, please get in
touch!).
If I must build the chart in Excel, can I incorporate it in my Access
report? If so, what's the best way -- push the chart from Excel using Access
as an automation server, or pull it from Access with Excel as the server?
Any useful books, websites, other refs. for this kind of stuff?
Thanks,
Dave
--
************************************************************************
Dave Stone e-mail: (e-mail address removed)
Computing Services Telephone: +44 131-650-3314
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: 0131-650-3308
Edinburgh EH8 9LJ
************************************************************************