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?
posted by BuddhaInABucket to Work & Money (2 answers total) 4 users marked this as a favorite
 
Sounds like a job for a Pivot Chart!

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]


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]


« 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.