Chart which changes when data is autofiltered

[honkin]

I have a sheet which has a chart in which shows the ongoing profit on the Y axis and the number of matches on the X axis. When I filter the sheet, the chart does not alter. How is it possible to have the chart only reflect the visible cells?

The data sets are Profit is AG21:AG883 and Matches is AH21:AH883

Is what I'm after possible at all: to have the chart change to reflect ONLY what is visible?

Thanks in advance

 

[jasonb75]

See if this article helps

Filtering charts in Excel | Microsoft 365 Blog

Have you ever had a dataset but only needed to chart certain parts of it? Here are 4 methods for filtering your chart so you don’t have to edit or remove your data to get the perfect chart: hide data on the grid, table filtering, filtering using table slicers, and filtering directly from the chart.

www.microsoft.com