HELP! Dynamic rolling 12 month chart.

Copper Contributor

Hi - Can anyone please help me to create a dynamic excel chart with 2 lines that goes back 12 months.

I have watched multiple tutorials mulltiple times, and can not get it to work.  

I would like to attach my file here, but cant see how.

Thank you.

2 Replies


Save your file to Onedrive or similar, share it and insert it link to access the file in your response.

The simplest way to create a dynamic chart is to table the data and then create a chart from the table. If you have some sample data then a chart could be created.