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

SherlynPeh
Posts
8
Registration date
Tuesday August 5, 2014
Last seen
August 14, 2014
- Aug 5, 2014 at 11:16 PM - Latest reply: TrowaD
Posts
2445
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2018
- 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
Posts
1
Registration date
Tuesday August 5, 2014
Last seen
August 5, 2014
- Aug 5, 2014 at 11:33 PM
0
Thank you
I also want to know the answers , somebody help ?

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