Perhaps with a macro. But an easier and more robust option is to use two chart objects, one column chart and one pie chart, and show/hide these as needed. You can use the Conditional option on the Layout tab in combination with a variable. You can use a button or text box with a Set Variable action to toggle the value of the variable.
variable: vShowPie (with initial value 0)
Conditional expression of the pie chart: =vShowPie
Conditional expression of the column chart: =NOT vShowPie
Set Variable action: set the variable vShowPie to the value =Not vShowPie
talk is cheap, supply exceeds demand