Solved

need breakdown by number of games bought

Posted on 2011-09-16
6
247 Views
Last Modified: 2012-05-12
I have a spreadsheet with three columns (see attached sample - note, all names have been changed).  I need an excel chart that would show many users bought 1 game, how many users bought 2 games, how many users bought 3 games, and so on.

How would I do that?   purchases.xlsx
0
Comment
Question by:aturetsky
  • 3
  • 2
6 Comments
 
LVL 7

Expert Comment

by:BusyMama
ID: 36550087
Hi!

I would use a pivot table and pivot chart for this.  It will count the number of games for you.  I've attached an example.
Pivot-Example.xls
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 36550276
Hi aturetsky,

A combination of a pivot table and then a COUNTIF function on the pivot table results should produce the chart you are wanting.  I have attached a workbook that does this.
 Purchases.xlsx

Your original data is on the first sheet ("Data"); a pivot that sums the number of games per person is on the second sheet ("Pivot") and the table and chart of the number of members per games purchased is on the third sheet ("Summary").
 screenshot
Since there is a large quantity of single-game purchasers, the graph doesn't show the 4- or 5-game quanity well.  You could change the y-axis to a logarithm scale to show them better.

-Glenn
0
 
LVL 1

Author Comment

by:aturetsky
ID: 36550279
Yes, but how do I get the breakdown I requested, not merely the number of games per user.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 1

Author Closing Comment

by:aturetsky
ID: 36550306
Excellent, Glenn - thanks so much.  I am about to post another, related question.  I will post a link to that question here shortly.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 36550360
Glad I could help...I will keep an eye out for your follow-up question.
0
 
LVL 1

Author Comment

by:aturetsky
ID: 36550383
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now