👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
📗 Get your free template here: »» cutt.ly/up4v2110M01FD
🎯 Your spreadsheet can use slicer selections as text to form chart and report titles with this technique. Produce flexible dynamic titles to extract the items chosen on a slicer.
If you want to learn more about pivot tables then have a look at my pivot table tips playlist:
cutt.ly/Up4PivotTableTips
======================================================================================
🕑 Video Timings:
00:00 Great Report - One Minor Issue
00:38 Download This Template
01:05 The Secret to The Method
02:05 Slicer Data to Cells - Step 1
04:48 Slicer Data to Cells - Step 2
06:31 Slicer Data to Cells - Step 3
08:06 Forming a Report Title
09:49 Dynamic Plural Adjustment
12:48 Breakout Long Titles to Rows
14:09 Link Title to Chart and Report
16:23 BONUS - Legacy Excel Work Around
18:59 Report Template Download
======================================================================================
🥉 Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.
Notes:
To select more than one item, hold Ctrl, and then select the items that you want to show.
To clear a slicer's filters, select Clear Filter Delete in the slicer.
You can adjust your slicer preferences in the Slicer tab (in newer versions of Excel), or the Design tab (Excel 2016 and older versions) on the ribbon.
Note: Select and hold the corner of a slicer to adjust and resize it.
If you want to connect a slicer to more than one PivotTable, go to Slicer - Report Connections - check the PivotTables to include, then select OK.
Note: Slicers can only be connected to PivotTables that share the same data source.
======================================================================================
📖 i've got a nice little report on screen here which is run by slicers i can click on these slicer buttons and the chart underneath updates and so do these figures here for sales and it would be perfect if it was for one small fact and that is that the titles don't change when the selections change so how can i get the selections from these slices to feed text on my spreadsheet i'll show you how in this video
as with virtually all of my videos you can download this spreadsheet with the link in the description or on the top comment instantly down to your computer no details asked for or required you can then work along to what i'm doing which make you learn better or you can just use it as your own template to create your own great looking reports when i looked into this problem i found a lot of information online about coding and quite significant sort of vba programs that tried to achieve this but actually there's a really straightforward way of achieving it it takes advantage of a feature of slicers because slicers can be connected to multiple pivot tables at the same time so this slicer as well as controlling my report for example could be controlling another pivot table on another sheet or just off off screen and that allows us basically to drive out results from these slices into a pivot table and then pick up the data in the pivot table and use it for the report titles so let's show you exactly how you might go about doing that
so all of this report is running from this table of data here and it is an excel table as you can probably tell i've got the ta
======================================================================================
#Up4Excel
#Up4PivotTables
#Up4ExcelIntermediate
Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
You get new video releases every week, packed full of ways to save time and impress those around you.
💎 Don't miss out and fall behind.....
🅾 SUBSCRIBE NOW 🅾
cutt.ly/Up4ExcelSub
======================================================================================
👀 Learn more with my playlist: Excel Pivot Tables Course
»» • Excel Pivot Tables Course
💥 Get a Shortcuts Cheat Sheet: »» www.up4excel.co.uk/shortcuts
🔑 Remove Excel File Open Passwords: »» • Excel File Locked? Lea...
🎁 Feel free to donate - your small gift will help me make better videos for you and others.
Thank You: www.paypal.me/Up4Excel
👉 Get ALL Up4Excel workbooks and templates on YOUR device in a structured searchable index….with free lifetime updates
📕 Up4Excel Downloads Pack: »» ml.up4excel.com/downloads_pack
Негізгі бет How to Get Excel Slicer Selections as Text - Dynamic Report Titles from Slicer Selections
Пікірлер: 7