Importing from Access to Excel, making chart

[allie357]

I have charts that I need to create from an imported Access query. I am using stored query calls in MSQuery

Here are the steps I have to go through:

There are commodities that can be listed in colunms A-M, but depending on which Commodities have spend determines on how they are imported. I then have to copy and paste the values down to the cells under Input for chart 2 and run the chart wizard on the second sheet to generate the chart. Then, I have to adjust the bar colors and manually enter the text boxes. Is there any way I can streamline this process? It is very time consuming.

Any help is appreciated.

 

[Philem]

There sure is a way you can streamline this. Have you tried to record an Excel macro that does the steps from the point JUST BEFORE hitting the Chart Wizard?

If you are able to fully record that macro, you can alter it to your taste, AND have Access run it via VBA automation! It's very slick, and I've done it many times in the past.

So, start with the Excel macro, and work from there.

HTH
-P