Excel 2024: Create Interactive Charts
March 19, 2024 - by Bill Jelen
It is easy to create interactive charts without using VBA. By default, if you hide rows in Excel, those rows will be hidden in the chart. The technique is to build a chart with every possible customer and then use a slicer or a filter to hide all except one of the customers.
Say that you have the following list of customers. Make the data into a table by using Ctrl+T.