A line chart with eight overlapping lines is basically a plate of spaghetti. Everyone can see something is happening, but nobody can tell what.
In this post, we'll do a full line chart makeover using Pivot Tables, a slicer, and three modern Excel array functions: TRIMRANGE, DROP, and HSTACK.
The result is an interactive chart where one click highlights a...