Shane,
I have replied your previous message,hope you like to help.

cho

"cho" wrote in message
...
Find me at

"ShaneDevenshire" wrote in
message ...
Hi Cho,

I will send you an example file without code. You can look it over and
see
if it incorporates the things you want.

However, it may also be easier to use a Pivot Chart depending on the
details
of what you want to do.

Give me an address where I can send the sample file.

--
Thanks,
Shane Devenshire


"cho" wrote:

Would you like to help me with that?
Please...!

"ShaneDevenshire" wrote in
message ...
Hi Cho,

In Access you do that in either a form are report and since Excel
does
not
have the same type of enviornment you can't do it as easily. It is
possible
to set up a report area in Excel and then as you move from row to
row
the
chart will update to reflect the row you are on, this can be
automated
with
VBA.

--
Cheers,
Shane Devenshire


"cho" wrote:

Hi Shane,
In access we can set the chart as a clip that can be changed
automatically
for every record displayed.Is it possible too in excel?.

"ShaneDevenshire"
wrote
in
message ...
Hi,

You need to create a connection to Access, here are the steps
you
need
to
do
one time only.

1. In Excel choose Data, Import External Data, New Database
Query
2. Pick MS Access Database from the list and click Next.
3. Locate the database, select it, and click OK.
4. Find the query on the left pane and either send all the
fields
(columns)
to Excel by clicking the button or click + and then
double-click
each of
the fields you want.
5. Click Next, Next, Next, Finish
6. Pick a destination cell and click OK.

Chart your data. Anytime you want to update the data from
access,
click
in
the data range and press the Refresh button on the External Data
toolbar.

Access does not need to be open or on your machine.
--
Cheers,
Shane Devenshire


"rahmad" wrote:

Hi All,
I have an access query and I want to use it as the data source
for a chart.Somebody told me that we can can provide
the excel chart to display the data from our query.How to do
that?
Wish somebody would like to help me.
thank's