Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have some data in Access from which I have to create Excel graphs every month (data would also be updated every month). So it's creating the same charts with different data every month.

Is there a way to automate this process? I'm thinking about Excel automatically pulling in the updated data for that month from Access and creating a similar graph to the one created last month (from last month's data) in a new Excel file.

I have the idea that a macro could do this but I don't know how.

share|improve this question

closed as not a real question by slhck Oct 12 '12 at 14:15

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

I'm not sure why you want to create graphs in Excel since you can create a report in Access and a graph to that or use "Graph Wizard". See the following example

MS Access: Create a graph

If you insist on Excel, I suppose you can save an Excel file with graphs and ODBC data link (Not importing data) as a template and use that to generate the monthly file.

share|improve this answer
I want to automate this process of making graph. I know I can do it in access but I want something (eg: running a sas code or VBA) that would automatically populate it in either access or excel. – Nupur Dec 6 '11 at 15:02
Was the stackoverflow answer by Tony any use? Refer to the following link – Supun Dec 6 '11 at 18:07
I am not a VBA expert. He was really helpful and I tried the code that he provided but I am getting errors and I could not figure out whats mistake I am making. I am looking for a more simple solution. I know SAS very well and thats why I am trying to figure out if I can link SAS to excel to automatically run the code and generate graphs. – Nupur Dec 7 '11 at 17:20
You have not responded to my comments of 7 December against the Stack Overflow version of this question so I do not know if you are still having problems or if you want something different. – Tony Dallimore Dec 28 '11 at 11:56

Not the answer you're looking for? Browse other questions tagged .