I’m currently working with a dataset in Excel that contains a product category column with string values, alongside multiple other columns. I would like to display the data in a chart as follows:

1. Filtering by Single Category: When I filter the data by a specific category, I want the chart to show the count of records for that category.
2. Multiple Categories: If I select multiple categories, I would like the chart to display the count for each selected category, with the count shown under the corresponding category name.