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

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

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

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

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

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