You want the user to click on a chart and then link to a new chart.
So maybe in Section 1 I click on a pie chart and it takes me to a bar chart on the next page?
Yes do that with Linking and it will autofilter for the new one. You can also set up an interaction.
You can use a hierarchy to filter the data in the new chart. So same chart - but it has the new data based on what the user clicked on.
If you literally want the pie chart to turn into a bar chart .... you might need to employ a magician. 😉
Tricia Aanderud
Twitter: @taanderud - Follow me!