Importing from Access to Excel, making chart

allie357

Board Regular
Joined
Jun 28, 2006
Messages
50
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.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Philem

Active Member
Joined
Jan 2, 2003
Messages
282
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 (y)
-P
 

Forum statistics

Threads
1,141,720
Messages
5,708,081
Members
421,545
Latest member
TWR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top