You can easily switch the member that the chart is based on.

Select the highlighted ellipsis to change the hierarchy member. This can also be an Excel range: