I am trying to quickly ascertain trend by days of week for a ratio column of data.
What is the best way to show a trend by day of week? Which day of week gets the highest ratio of followers? Would like to see all data for Monday, then all data for Tuesday, etc and then comparing the days of the week.
The data set will continue to grow, so I need something more than a bar chart with a basic trendline. That won't give me a clear enough picture.
See attached data set an chart I have so far.
Here's a start:
You could add a column and look up the weekday so that you can group on week days in a Pivot Table.
New column formula: =LOOKUP(WEEKDAY(A3),{1,2,3,4,5,6,7},{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"})
Copied down.
I would convert the data range into an Excel Table and base the Pivot Table on this data table. As new data are added you just need to right-click on the PT and choose Refresh.
Because it is a Pivot Table/Chart you can drag row fields around to get the views you want.
Excel Help_802623.xlsx
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks