excel chart with data source from an access query

[rahmad]

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

 

[ShaneDevenshire]

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.

 

[cho]

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?.

 

[cho]

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

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.

 

[cho]

Find me at (e-mail address removed)

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.

 

[cho]

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

cho

Find me at (e-mail address removed)

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.

does

not

row

the