Excel 2024: Build Dashboards with Sparklines and Slicers


May 24, 2024 - by

Excel 2024: Build Dashboards with Sparklines and Slicers

New tools debuted in Excel 2010 that let you create interactive dashboards that do not look like Excel. This figure shows an Excel workbook with two slicers, Region and Line, used to filter the data. Also in this figure, pivot charts plus a collection of sparkline charts illustrate sales trends.

A dashboard with two charts, sparklines and two slicers.
A dashboard with two charts, sparklines and two slicers.

You can use a setup like this and give your manager's manager a touch screen. All you have to do is teach people how to use the slicers, and they will be able to use this interactive tool for running reports. Touch the East region and the Books line. All of the charts update to reflect sales of books in the East region.

continue reading »

More Reading


Excel 2024: Use a Pivot Table to Compare Lists

Excel 2024: Use a Pivot Table to Compare Lists »

May 22, 2024 - by Bill Jelen


When you think of comparing lists, you probably think of VLOOKUP. If you have two lists to compare, you need to add two columns of VLOOKUP.

Excel 2024: Replicate a Pivot Table for Each Rep

Excel 2024: Replicate a Pivot Table for Each Rep »

May 20, 2024 - by Bill Jelen


Here is a great trick I learned from Southern California based Excel consultant Szilvia Juhasz.

Excel 2024: Make Pivot Tables Expandable Using Ctrl+T

Excel 2024: Make Pivot Tables Expandable Using Ctrl+T »

May 15, 2024 - by Bill Jelen


If you choose all of columns A:J and you later want to add more records below the data, it takes only a simple Refresh to add the new data instead of having to find the Change Data Source icon. In the past, this made sense. But today, Change Data Source is right next to the Refresh button and not hard to find.

read more articles »

Featured Products


MrExcel 2024 Igniting Excel

February 2024

This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.


Power BI for the Excel Data Analyst

July 2022

A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.


see more products »