![]() Next, go to the Table Tools – Design tab and click on “Insert Slicer”. Make sure the “My table has headers” is checked. Click anywhere inside this data and press Ctrl + T to convert it into an Excel table. They are sold through multiple types of retailers & order sources. It has various products that fall into multiple categories and types. This is sample sales data taken from an outdoors & sports equipment company. They are available only in Excel Tables and Pivot Tables. Slicer BasicsĮssentially, by creating slicers in Excel, you are doing the same thing as filtering by using a different interface. This can be overcome by using the slicer tool in excel. Just imagine yourself presenting some data in a meeting with everyone waiting and looking at you while you click each filter’s button to show data that is required. All these filters can be used to great effect, but they can become cumbersome and clunky to use – especially when there are multiple columns to filter. ![]() Quantity column drop-down -> Number Filters -> Greater Than -> 40 In the screenshot above, a number filter is applied to show only values greater than 40. For example, filters can be applied to the source data, which will change the chart to reflect only the filtered values: This is exactly how interactivity is brought to charts – by changing the source data. This means the data can be manipulated to bring about changes in the chart. Any changes in the source data will reflect in the chart. If new data is entered just below the existing data, it will be recognized and updated in the chart automatically:Īs you can see, charts depend on how the source data is maintained. Next, select the data and insert a line chart, normally through the Insert tab option. Another indication is a new Tab that appears on the menu (ribbon) called Table Tools -> Design. This will reformat the data and add filter dropdowns to it. To convert a range of data into a table, select it and go to the Insert Tab > Table. To understand this, let us look at a simple inventory that records the in-flow and outflow of Item A. Hence, if a chart is linked to a table, and growth of data will be updated in the chart automatically. This means any amount of new data added will still only be a part of that particular table, without having to manually increase the selection of the data range. One of the features of an Excel Table versus a normal data range is that it can accommodate new data, while still retaining the same reference. The problem of growing data is easily fixed by converting the source data into an Excel Table. Now, let us look at how to make them more dynamic and interactive. In other words, charts are by default, static. So, whenever new data is added, the chart will not take that into account automatically and therefore does not update itself. ![]() ![]() Now, the thing about charts is that they are linked to a fixed source of data. It is much more advisable to use a bar, column or line chart.īecause of its advantages, it is very common to present data using charts. For example, if you have monthly sales data for Product X, using a pie chart would not make any sense. From the various types of charts, always select the chart type that makes the most sense for the data that you want to portray. In recent versions of Excel, you even get an option to recommend a chart, based on the type of data you have. But with a chart, you can grasp this at a glance.Ĭharts are pretty easy to make – just select data and select an appropriate chart type from the Insert Tab. You would need to read through a lot of data to understand what is happening. Here, learn about Excel Slicer.īefore we get into the slicer-controlled extravaganza, let us understand a bit about charts and how to make them interactive.Įxcel charts make it very easy to visualize all the data that is entered into spreadsheets. This is where slicers come into the picture. Plus, we want to be able to slice the chart to see whatever we want to see at that point in time. Once the data starts growing, we want to see the effect of the growing data on the chart immediately without having to do any manual settings every time. We all have some of the other time used Charts in Excel, but always struggle with when it comes to growing data. ![]()
0 Comments
Leave a Reply. |