We will learn to create graphs which can be handled by data filters to look more easy and customizable.
Data preparation
Let us create a chart data for 2 products with different categories.
We have the cost and profit values in this chart. Convert this data to tables to make it more accessible.
The table lools like follows:
The chart
Create a chart from the same now:
The chart will look like this:
Now we can easily filter the category as shown below:
After filtering the graph will look like this:
We can also try to remove a product from the list of products.
Please note that this is a small table but for more number of products and more categories it will be very handy to filter the table and how it reflects on the charts instantly:
Product disappeared from the chart:
We can insert slicer like this also:
This is how slicers look like:
It will very easy to click on the slicer values instead of the filtering:
Please find attached Excel file for reference.
