Excel Dynamic Chart with Drop-Down

Excel Dynamic Column Chart with Average Line Learn how to create an interactive chart in Excel that switches views depending on the selection from the drop-down list. In addition to creating dynamic chart ranges, I also show you how to create combination charts in

Optimized Excel Line Charts: Prevent Drop to Zero

You'll face two main problems when creating dynamic line charts in Excel: Problem 1: Line series crashes to zero once you attempt to cut-off the series from a certain point. For example you'd like to control the length of the line based on a

Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets: VLOOKUP & INDEX MATCH in Excel In Excel, it’s relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using only one formula? In this tutorial, I'll show you

Excel Dependent Drop Down List with Tabular Data

Handle dynamic data validation lists that refer to parts of your table only  Excel Dependent Drop Down List with Tabular Data without Named Ranges   There are some cases where you need to create a dependent drop down list using a source

Symbols in Pivot Slicers

A neat pivot slicer trick Symbols in Pivot Slicers Give your report a customized look by replacing text with symbols in your Pivot Slicers. Obviously you can't do that with every Pivot Table filter, but replacing text with symbols whenever it makes