Automation of pie chart using the values in excel [Solved/Closed]

SherlynPeh 8 Posts Tuesday August 5, 2014Registration date August 14, 2014 Last seen - Aug 5, 2014 at 11:16 PM - Latest reply: TrowaD 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen
- 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!
See more 

4 replies

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

[Signature removed by Moderator]
TrowaD 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen - Aug 7, 2014 at 10:54 AM
0
Thank you
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
SherlynPeh 8 Posts Tuesday August 5, 2014Registration date August 14, 2014 Last seen - Aug 8, 2014 at 12:40 AM
0
Thank you
Thank you so much for your help Trowa :) I think I got it !
TrowaD 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen - Aug 11, 2014 at 11:29 AM
We are here for you if you need further assistance Sherlyn!