How to split a line chart by day of the week
February 1, 2015 9:01 AM Subscribe
ExcelFilter: I have two columns of data- column one is every day in a month, column two is attendance. I'd like to have a line graph that shows the data split into 7 lines- one for Mondays, one for Tuesdays, etc. How can I do this?
Response by poster: Thanks Ruthless Bunny! I'm not getting it to look exactly how I want but that definitely got me 90% of the way there- I can probably figure out the rest from fiddling with it.
posted by BuddhaInABucket at 10:05 AM on February 1, 2015 [1 favorite]
posted by BuddhaInABucket at 10:05 AM on February 1, 2015 [1 favorite]
« Older Musical Film from the 1950's -Filter | Where can I find discount kids' khaki jumpsuits or... Newer »
This thread is closed to new comments.
First pivot on Day of Week. Then add Attendance figures as your values.
Then do a line chart with Day of Week on X axis and values on the Y.
Here's a page you may find handy.
posted by Ruthless Bunny at 9:12 AM on February 1, 2015 [2 favorites]