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