You can use the keyboard shortcut control + shift + L. One way to apply a filter is to click the Filter menu on the Data tab. This is a case where it makes sense to add a filter to the data itself, and then use that to exclude the data we don't want. The way the entries are listed in the filter, I'll have to uncheck a lot of checkboxes. If I insert a line chart, Excel automatically builds a condensed horizontal axis and plots all the data.Īnd I can easily use the Chart Filters menu to exclude everything but the close price.īut what if I only want to show data from 20? When plotting unsummarized data, the chart filter may not be convenient.įor example, here we have historical stock data for Microsoft covering more than 15 years in more than 100 rows of data. In this video, we'll look at how to filter larger sets of data in a table with filters applied.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |