Thread: Compare data values for same period in previous year
View Single Post
 
Old 05-01-2021, 04:08 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Merge your 2 years tables into one and pivot the data.
In the attached two sheets with slightly different arrangements of pivot tables, on the second sheet a chart too.
I think you're using Excel 2007 so I hope the pivots are still compatible.
Attached Files
File Type: xlsx msofficeforums46902Energy.xlsx (28.3 KB, 18 views)
Reply With Quote