From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Dynamically presenting data via chart slicers

Dynamically presenting data via chart slicers - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Dynamically presenting data via chart slicers

- [Instructor] The slicer feature 2 was introduced in Excel 2010, 3 but only available with pivot tables. 4 Starting in Excel 2013, if you convert data to a table, 5 then you can use a slicer. 6 Now, if you've not used the feature, 7 you're not even aware what it is, 8 it's a visual way to do filtering. 9 Now, let's imagine 10 we want to make a presentation of this data. 11 We might want to show different states at different times, 12 and we might also want to use a chart. 13 Let's convert this data to a table. 14 There are four ways to do this. 15 You can do it from the insert tab in the ribbon. 16 There's a choice called table. 17 From the home tab in the ribbon. 18 You can also choose format as table. 19 You can press Ctrl + L, think of list, or Ctrl + T. 20 I'll simply press Ctrl + T. 21 Now, within the data, make sure you have no empty rows, 22 empty columns, and you don't have to highlight it. 23 Make sure also…

Contents