Easy Butterfly Charts with Excel Pivot Tables 

Butterfly charts, or two bar charts going in opposite directions, can be a show-stopper of a data visualization technique. In Excel, two Pivot Tables working together can create this effect easily. Neil Malek from Knack Training demonstrates how to use Slicers to direct a dynamic version of the butterfly chart.
Subscribe to Everyday Office for more tutorials like this!