Previous Topic Next Topic

Automation of pie chart using the values in excel

Solved/Closed
SherlynPeh Posts 8 Registration date Tuesday 5 August 2014 Status Member Last seen 14 August 2014 - 5 Aug 2014 à 23:16
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 11 Aug 2014 à 11:29
Hi,

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

Thanks!
Related:

3 responses

Réponse 1 / 3
seotrade2011 Posts 1 Registration date Tuesday 5 August 2014 Status Member Last seen 5 August 2014
5 Aug 2014 à 23:33
I also want to know the answers , somebody help ?

[Signature removed by Moderator]
Réponse 2 / 3
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
7 Aug 2014 à 10:54
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
Réponse 3 / 3
SherlynPeh Posts 8 Registration date Tuesday 5 August 2014 Status Member Last seen 14 August 2014
8 Aug 2014 à 00:40
Thank you so much for your help Trowa :) I think I got it !
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
11 Aug 2014 à 11:29
We are here for you if you need further assistance Sherlyn!

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

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

6 responses