macro to create pie chart based on dynamic ranges

Dear experts.

Unfortunately my VBA knowledge is not good enough yet so I hope to get help from anyone on that forum.

Basically what I need is a macro which will create pie graph based on dynamic ranges.

I have inputed example workbook for better understanding what I am expecting to get + I've made example graph I would like to get.
I got 3 tabs in my workbook - the one on which I do need graph is 'Efficiency Report'.
In that tab I got macro which is generating table based on specified criteria.
And from that table I do need graph.
And because that table is generated based on criteria it might be 10 rows, 20 or 50 rows long. That's why I need automation for that graph.
Data which I do want to graph is percentage of downtime reasons (columns L:AJ, currently row 23).
I will appreciate any help with that.
If someone would like to help me with it but need more info please let me know and I'll try to give as many info as required.
Thanks in advance.

Just change the formula

L23: =IF(L21=0,NA(),L21/$K21)

The formula change will get read of the datalabels for zero items, which you had a red cross through.

To automate the chart use

Please Login or Register  to view this content.

And call that at the end of the CreateTable routine,

Please Login or Register  to view this content.

Please Login or Register  to view this content.