I have a PivotTable connected to a Horizontal Bar Chart. When I filter the content to be displayed in the Chart (by using the Slicer), the Chart did not resize according to the entries displayed. This made the bars either become HUGE or too small. As a work-around, I made a Macro that will resize the chart according to the rows displayed in the PivotTable.
The working solution was then to click slice, click the graph, and click the "ResizeChart" Macro button I've made.
However, I would like the Macro to auto-execute when I click the slicer. How, please?
