How to Create Charts with Filtered Data in Excel

In this article, 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.

chart with filtered data table

The table lools like follows:

chart with filtered data table data table

The chart

Create a chart from the same now:

chart with clustered column

The chart will look like this:

basic chart with filtered data table

Now we can easily filter the category as shown below:

chart with filtered data table filter category

After filtering the graph will look like this:

chart with filtered data table filtering the graph

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:

chart with filtered data table remove the product

PRoduct disappeared from the chart:

chart with removed product

We can insert slicer like this also:

chart with filtered data table insert slicer

This is how slicers look like:

chart with filtered data table chart slicer

It will very easy to click on the slicer values instead of the filtering:

chart with filtered data table click slicer

Please find attached Excel file for reference.

How to Use Slicers to Filter Charts

Slicers are a powerful tool that can be used to filter charts. They allow you to quickly and easily select the data that you want to see in a chart.

To use slicers to filter a chart, you first need to add slicers to the chart. You can do this by right-clicking on the chart and selecting Add Slicer.

See also  How to Create Pie of Pie Chart in Excel

Once you have added slicers to the chart, you can select the data that you want to see in the chart by clicking on the slicers. For example, if you have a chart that shows sales data for different products, you can use slicers to select the data for a specific product or a range of products.

Slicers are a great way to make charts more interactive and informative. They can be used to focus on specific data points, compare different data sets, and identify trends and patterns in your data.

Here are some additional tips for using slicers to filter charts:

  • Use slicers to focus on specific data points. For example, you could use a slicer to focus on the sales for a specific product or a range of products.
  • Use slicers to compare different data sets. For example, you could use slicers to compare the sales for different products or different regions.
  • Use slicers to identify trends and patterns in your data. For example, you could use slicers to identify the products that are selling the best or the regions that are generating the most sales.

By following these tips, you can use slicers to make your charts more interactive and informative.

Key Takeaways

  • Charts are a great way to visualize data and make it easier to understand.
  • Filtering data can be used to focus on specific values in a chart.
  • Slicers are a powerful tool that can be used to filter charts quickly and easily.
  • By following the tips in this article, you can create charts that are informative and easy to understand.
See also  How to Make Dynamic Chart From Static Chart

FAQ

  • Q: How do I filter data in a chart?
  • A: You can filter data in a chart by using the **Filter** button on the Home tab. This will display a list of filters that you can apply to the data.
  • Q: How do I use slicers to filter charts?
  • A: You can use slicers to filter charts by right-clicking on the chart and selecting **Add Slicer**. This will add a slicer to the chart that you can use to select the data that you want to see.