Add Pie Chart to Active sheet and reference cells

[Lee Francis]

Hi Guys,


I hope you can help.


I have a macro which searches two saved workbooks for a matching reference and creates a new worksheet containing all of the matches found.


This works fine


What I want to do is call a simple macro that adds a pie chart to the active sheet and references a group of data each time. Resizing the chart and placing it as desired would be great too.


Sounds simple but I am really struggling to do this.


Can anyone help with this? Any help would be HUGELY appreciated.


Thanks for your help guys


Lee.