Setting up Macro to create pie chart.
"Hamish" wrote:
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?
Never mind. I realised that I could just right click the chart and change
the data range. This makes it pretty easy.
|