Excel 2024: Create Interactive Charts


March 19, 2024 - by Bill Jelen

Excel 2024: Create Interactive Charts

It is easy to create interactive charts without using VBA. By default, if you hide rows in Excel, those rows will be hidden in the chart. The technique is to build a chart with every possible customer and then use a slicer or a filter to hide all except one of the customers.

Say that you have the following list of customers. Make the data into a table by using Ctrl+T.

Customers down column A, Q1 through Q4 across the top. The AutoFilter icons appear across the top row.
Customers down column A, Q1 through Q4 across the top. The AutoFilter icons appear across the top row.

continue reading »

More Reading


Excel 2024: Paste New Data on a Chart

Excel 2024: Paste New Data on a Chart »

March 18, 2024 - by Bill Jelen


You might be responsible for updating charts every month, week, or day. For example, in my last job, a collection of charts were updated during the month-end close process. The charts would track progress throughout the year.

Excel 2024: Create Perfect One-Click Charts

Excel 2024: Create Perfect One-Click Charts »

March 15, 2024 - by Bill Jelen


One-click charts are easy: Select the data and press Alt+F1. What if you would rather create bar charts instead of the default clustered column chart?

Excel 2024: New Threaded Comments Allow Conversations

Excel 2024: New Threaded Comments Allow Conversations »

March 12, 2024 - by Bill Jelen


Threaded comments debuted in 2018. When you insert a comment, Excel stores the comment, the author, the date, and time. When a co-worker sees your comment, they can click Reply and add a new comment to the same cell. Each set of comments lists the author, date, and time.

read more articles »

Featured Products


Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

December 2021

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.


Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.


see more products »