PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.
How-To Geek on MSN
I made a dynamic Excel timeline in 10 minutes (and you can too)
Transforming a simple line chart into an adaptable timeline is easier than you think.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results