![]() The below sections will give you some hints on how to get started. How to use slicer in ExcelĮxcel slicers were designed as user-friendly filter buttons, so their use is simple and intuitive. If the slicer box gets hidden behind the chart, right-click the slicer, and select Bring to Front from the context menu. For this, make the chart area bigger and the plot arear smaller (simply by dragging the borders), and then drag the slicer box to the empty space: Optionally, you can place the slicer box within the chart area. Or, you may want to make a few improvements, for example, hide the filter buttons on the chart, which have become redundant since you are going to use the slicer for filtering. Once you have a slicer, you can use it to filter the pivot chart data straight away. This will insert the already familiar slicer box in your worksheet:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |