Hello. I know there is a way to take data from an Access query and have it automatically generate an Excel chart. I have seen it done, however, I cannot seem to figure it out.

My VBA skills are NOT GOOD!

Is there a quick and easy way to have a graph/chart automatically generate in Excel using a Macro? Also need to know how I set up the template in Excel.

Very new to this.

If anyone can point me in the right direction!!!

Thanks.