So, i have stuff like this, movies that i've rated in several days:
6.11
6.11
7.11
9.11
11.11
12.11
12.11
12.11
13.11
As you could notice, 6 and 12 are there more than once = i rated more movies that day.
I need something to tell me how many movies have i rated each day (+ graph out of it)
Attachment 139015
EDIT: number of rated movies each day, actually NOT rating of the movies
If you dont understand anything then tell me and i will try to make it more comprehensible.
Last edited by Isomatrix; 01-31-2012 at 03:02 PM.
Isomatrix,
Welcome to the forum!
I was unable to open your attachment. As such, I have created an example workbook based on the criteria you described. It uses a pivot table to get the desired information, and the graph is based on the pivot table.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi Isomatrix and welcome to the forum,
You could even expand on TigarAvatar's example and see if it was a good or bad day by getting the average of the ratings in the Pivot Table. See attached.
One test is worth a thousand opinions.
Click the * below to say thanks.
Aah, okay, thankz for that stuff.
Last edited by Isomatrix; 01-31-2012 at 03:07 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks