'Application.Caller returns the object that started the macro End With statement allows you to write shorter code by referring to an object only once instead of using it with each property. 'Redimension variable Series in order to make the array variable grow dynamically 'Dimension variables and declare data types

Type button names and make sure they match the table data in the first column (Revenue, Earnings and Employees).

Press with right mouse button on on rectangle and select 'Edit text'.

Create three rectangles below the chart.

Press with left mouse button on 'Rounded Rectangle'.

Press with left mouse button on 'Shapes' button.

Press with left mouse button on 'Switch row/column' button.

Press with right mouse button on on chart.

Press with left mouse button on '2D Clustered column'.

Press with left mouse button on 'Columns' button.

Select any cell in your Excel defined Table.

Press with left mouse button on 'Table' button.

The animated image below demonstrates the functionality of these buttons. Remove highlight from button if press with left mouse button oned on a second time.Highlight selected button programmatically.Filter an Excel defined Table programmatically based on selected buttons.Slicers let you filter values in the Excel defined Table, the chart is instantly refreshed based on your selection.Īnyway, this article may still be interesting, you will in this article learn to No VBA code is required if you choose to use slicers. I recommend you use slicers instead if you own Excel 2010 or a later version Slicers were introduced in Excel 2010, see image above. This article describes how to create an interactive chart, the user may press with left mouse button on a button or multiple buttons and the chart shows corresponding data based on the selected buttons. Author: Oscar Cronquist Article last updated on September 03, 2019

Create pie chart in excel 2010