I need to create a macro to make pie charts. I have about 15 pie charts to
make and I would like them all to be the same. They use different data though.

I have created a macro which works successfully for one graph.

However I cant select different data. The macro always creates a chart from
the data used to record the macro.

Is there a way we can select which data we want to use, then get the macro
to make a graph representing that data?