excel chart with data source from an access query
 

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

excel chart with data source from an access query
 

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

excel chart with data source from an access query
 

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

excel chart with data source from an access query
 

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

excel chart with data source from an access query
 

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

excel chart with data source from an access query
 

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

excel chart with data source from an access query
 

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

excel chart with data source from an access query
 

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