Show Years in Separate Lines in Excel Pivot Chart

If you make an Excel pivot chart to show monthly data, a line chart might have all the dates in a single line. This video shows how to group the dates, if needed, and how to show years in separate lines. It just takes a simple step – move the Years field to the pivot chart’s Legend (Series) area.

Continue reading “Show Years in Separate Lines in Excel Pivot Chart”