Automation of pie chart using the values in excel

Solved/Closed
SherlynPeh Posts 8 Registration date Tuesday August 5, 2014 Status Member Last seen August 14, 2014 - Aug 5, 2014 at 11:16 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Aug 11, 2014 at 11:29 AM
Hi,

Anybody knows how to convert values into pie chart using macros instead of the insert function?

Thanks!

3 replies

seotrade2011 Posts 1 Registration date Tuesday August 5, 2014 Status Member Last seen August 5, 2014
Aug 5, 2014 at 11:33 PM
I also want to know the answers , somebody help ?

[Signature removed by Moderator]
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Aug 7, 2014 at 10:54 AM
Dear members,

Try recording a macro before creating the pie chart.

Once the recording is done you can remove the pie chart and run the recorded macro to instantly create the chart.

Is that what you were looking for?

Otherwise specify in great detail.

Best regards,
Trowa
0
SherlynPeh Posts 8 Registration date Tuesday August 5, 2014 Status Member Last seen August 14, 2014
Aug 8, 2014 at 12:40 AM
Thank you so much for your help Trowa :) I think I got it !
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Aug 11, 2014 at 11:29 AM
We are here for you if you need further assistance Sherlyn!
0