Excel Chart in a Access Form

  • Thread starter Thread starter Gilles
  • Start date Start date
G

Gilles

Hello,

Does someone have an example of using an Excel Scatter
plot (XY plot) as an imbeded object in an Access form.

Gilles
 
Use an unbound opject frame. Set the Source Doc property to the path to the
workbook and the Source Item property to the name of the worksheet +
reference to the chart.

Examples:
Source Doc: C:\My Documents\Glaucoma Screening Database\StatisticsReport.xls
Source Item: Sheet1![StatisticsReport.xls]Sheet1 Chart 7
 
Yap, the object is in my form.
1) Now how do I refer to it and add data from a table to
it?

2)I would prefer not to refer to an existing file but
rather reserve the option of saving the end result.

Gilles
-----Original Message-----
Use an unbound opject frame. Set the Source Doc property to the path to the
workbook and the Source Item property to the name of the worksheet +
reference to the chart.

Examples:
Source Doc: C:\My Documents\Glaucoma Screening Database\StatisticsReport.xls
Source Item: Sheet1![StatisticsReport.xls]Sheet1 Chart 7


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hello,

Does someone have an example of using an Excel Scatter
plot (XY plot) as an imbeded object in an Access form.

Gilles
Click to expand...


.
Click to expand...
 
1) -- Use transferspreadsheet to send data from Access to Excel
2) -- It's an Excel chart you want so you need to link to it because you are
dynamically changing the chart in 1).


Yap, the object is in my form.
1) Now how do I refer to it and add data from a table to
it?

2)I would prefer not to refer to an existing file but
rather reserve the option of saving the end result.

Gilles
-----Original Message-----
Use an unbound opject frame. Set the Source Doc property to the path to the
workbook and the Source Item property to the name of the worksheet +
reference to the chart.

Examples:
Source Doc: C:\My Documents\Glaucoma Screening Database\StatisticsReport.xls
Source Item: Sheet1![StatisticsReport.xls]Sheet1 Chart 7


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hello,

Does someone have an example of using an Excel Scatter
plot (XY plot) as an imbeded object in an Access form.

Gilles
Click to expand...


.
Click to expand...
Click to expand...
 
1/2) Id prefer to work entirely with access and use excel
only for it's better graphing capability than the office
Graph library. And yes I am dynamically changing the graph
and at the end I would like to save the data with the
graph in an excel workbook.

-----Original Message-----
1) -- Use transferspreadsheet to send data from Access to Excel
2) -- It's an Excel chart you want so you need to link to it because you are
dynamically changing the chart in 1).


Yap, the object is in my form.
1) Now how do I refer to it and add data from a table to
it?

2)I would prefer not to refer to an existing file but
rather reserve the option of saving the end result.

Gilles
-----Original Message-----
Use an unbound opject frame. Set the Source Doc
Click to expand...
property
to the path to the
workbook and the Source Item property to the name of
Click to expand...
the
worksheet +
reference to the chart.

Examples:
Source Doc: C:\My Documents\Glaucoma Screening Database\StatisticsReport.xls
Source Item: Sheet1![StatisticsReport.xls]Sheet1 Chart 7


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hello,

Does someone have an example of using an Excel Scatter
plot (XY plot) as an imbeded object in an Access form.

Gilles


.
Click to expand...
Click to expand...


.
Click to expand...
 
That's exactly what you get when you use Transferspreadsheet and you link to
Excel. In my previous example, the Source Doc is the workbook, Sheet 1 is
the worksheet and Chart 7 is the chart on Sheet 1. The data that is graphed
is in a range on Sheet 1 and Transferspreadsheet puts the data in the range
from Access.


1/2) Id prefer to work entirely with access and use excel
only for it's better graphing capability than the office
Graph library. And yes I am dynamically changing the graph
and at the end I would like to save the data with the
graph in an excel workbook.

-----Original Message-----
1) -- Use transferspreadsheet to send data from Access to Excel
2) -- It's an Excel chart you want so you need to link to it because you are
dynamically changing the chart in 1).


Yap, the object is in my form.
1) Now how do I refer to it and add data from a table to
it?

2)I would prefer not to refer to an existing file but
rather reserve the option of saving the end result.

Gilles
-----Original Message-----
Use an unbound opject frame. Set the Source Doc property
to the path to the
workbook and the Source Item property to the name of the
worksheet +
reference to the chart.

Examples:
Source Doc: C:\My Documents\Glaucoma Screening
Database\StatisticsReport.xls
Source Item: Sheet1![StatisticsReport.xls]Sheet1 Chart 7


--
PC Datasheet
Your Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
www.pcdatasheet.com


message
Hello,

Does someone have an example of using an Excel Scatter
plot (XY plot) as an imbeded object in an Access form.

Gilles


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top