Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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!
Related:

3 responses

Answer 1 / 3
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
Answer 2 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
Answer 3 / 3
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 11, 2014 at 11:29 AM
We are here for you if you need further assistance Sherlyn!
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses