Pie chart from access

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

Question Boy

I would like to know if there is a way for me to create a set of pie chart
which get their source information from an access database set of queries (1
query per chart) and then update when the workbook is opened? If so, what is
this called so I can google it specifically? Any good ressource that
demonstrate the basics to bring me up to speed?

Thank you,

QB
 
I don't believe you can link and Access table or query to an Excel
spreadsheet. However, you could set up a routine to automatically export the
Access table into Excel. Once the data was exported from the database, your
Excel pie charts would update too. The link below provides some information
on how to do.

http://office.microsoft.com/en-us/access/HP010950951033.aspx
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie Chart Troubles 1
Pie Chart - Columns 1
Pie Chart 1
Basic Categorical Pie Chart Question 2
Pie chart problem 2
How can I reset the default pie chart label "Other" to "Equity"? 1
"circular" concentric charts - like a pilot's plotting/nav computer 1
Pie chart-remove series w/out changing percent in pie 1

Back
Top