Link an excel spreadsheet and graph to an Access Query

[Tamer Seoud]

Hi,
I have an Access query that I wanted to analyze with MS
Excel. I included two worksheets in the Excel file (one
containing the data from the Access query and the other is
the graph representation of the data). I want the Excel
file to be updated whenever I update my Access query. How
to do this?

Do I have to link the Excel file to the Access query? If
so, how can I achieve this?
Or there is another way through VBA Codes.

Please Advise, this will help me a lot