Hello,
I would like to know whether it is possible to change the current pie chart into another one, by clicking on one piece of the pie. In the attachment I added an example.
I want the total sales (from the continents) in one pie chart. Then, if I click on one part of the pie (for example Europe) I want that the pie chart changes in to a pie chart of Europe.
Is there a VBA code or other solution to accomplish this?
Thanks in advance!
Bookmarks