Mike Waller
asked on
Excel Pivot Table and column chart to display traffic by year
Hi there. I need a pivot table and a column chart that shows how much traffic each widget category received by year. I've attached some sample data.
Any ideas experts?
pivot-table-and-column-chart.xlsx
Any ideas experts?
pivot-table-and-column-chart.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay and how did you change the labels from month to years in row 4?
Right click on any date, choose Group and in the next window, click on Year, click on Month to unselect it and click OK.
Watch this short video demo.
https://www.screencast.com/t/76KdbkQEPYho
https://www.screencast.com/t/76KdbkQEPYho
ASKER
Great video Neeraj and everything looks great in Excel standalone but I'm using Excel online and can't seem to group by year. Any ideas?
No idea about the excel online and not sure what functionalities are available in there. :)
ASKER
Awesome, thanks Neeraj!
You're welcome!
ASKER