Do you like pie? If so, check this out.

ivbaseball06 · 02-08-2013, 04:29 PM

Sorry, not the yummy pie.

I got curious this afternoon so I made this pie chart. I wanted to see what proportion of my OSU autograph collection was divided among the different companies. Some interesting discoveries:

--I knew that I wasn't a big fan of Panini cards, but I didn't realize how small they really were in my collection.

--Meanwhile, you can clearly see my love for Upper Deck and Press Pass.

--The Donruss/Playoff section surprised me with its size too, since most of my collection is OSU uniform and they haven't had a whole lot of that. I guess that most of my non-OSU uniform autographs belong to Donruss/Playoff to give them that large of a market share.

If you guys happen to have a nice Excel database for your cards, I'd love to see a similar break down!

bktochi4 · 02-08-2013, 04:38 PM

I do have mine in excel - how did you make that? haha.

ivbaseball06 · 02-08-2013, 04:40 PM

Quote:

Originally Posted by bktochi4

I do have mine in excel - how did you make that? haha.

For you and anyone else interested:

1. Copy out the column that has the brand names (UD,PP,Panini,etc.) and paste it in Word or a text editor.

2. Ctrl+F to do a Find. Search for each brand name and write down how many of each you have.

3. Go back to Excel. Make a column with the brand names and then put the numbers for each in the column beside.

4. Insert > Charts > Pie Chart. Then when it asks for the data just select both of those columns you just made.

5. It will automatically make a legend for you. I took the whole thing into Photoshop to overlay the names instead of a legend. That's optional.

bktochi4 · 02-08-2013, 04:49 PM

Next dumb question: Now that I have the chart, how do I post it into this?

ivbaseball06 · 02-08-2013, 04:51 PM

Quote:

Originally Posted by bktochi4

Next dumb question: Now that I have the chart, how do I post it into this?

Right-click -> Save as picture.

Then upload it to Photobucket or IMGUR and then bring the URL in here like normal.

bktochi4 · 02-08-2013, 04:58 PM

I like pie - but for whatever reason, I am technologically challenged today.

My data, however, is as follows:

Topps: 60%
Other: 5%
Panini: 21%
Sage: <1%
Upper Deck: 14%

Just visualize the pie.

frankhoover · 02-08-2013, 05:08 PM

95% Topps
4% Panini
1% Leaf

Since I mainly just collect cam's chrome cards, I deal mostly with topps. I will randomly buy a different company's cards, if I see something I like.

Sorry, but I wish I had a pie chart to visualize my cards. Good job on yours OP, looks good.

02-08-2013, 04:29 PM	#1 (permalink)
ivbaseball06 Member Join Date: Jan 2012 Location: Columbus, Ohio Posts: 2,040 ivbaseball06	Do you like pie? If so, check this out. Sorry, not the yummy pie. I got curious this afternoon so I made this pie chart. I wanted to see what proportion of my OSU autograph collection was divided among the different companies. Some interesting discoveries: --I knew that I wasn't a big fan of Panini cards, but I didn't realize how small they really were in my collection. --Meanwhile, you can clearly see my love for Upper Deck and Press Pass. --The Donruss/Playoff section surprised me with its size too, since most of my collection is OSU uniform and they haven't had a whole lot of that. I guess that most of my non-OSU uniform autographs belong to Donruss/Playoff to give them that large of a market share. If you guys happen to have a nice Excel database for your cards, I'd love to see a similar break down! __________________ Ohio State Buckeyes Supercollector! Photobucket: www.tinyurl.com/ivbaseball06 Wantlist: http://i.imgur.com/xkUmH.png Buckeyes PC: (5) 1/1 Autos, (514) Autos, (41) GU/Patches, (91) RC/Inserts/Parallels Last edited by ivbaseball06; 02-08-2013 at 04:44 PM.

02-08-2013, 05:08 PM	#7 (permalink)
frankhoover Member Join Date: Jun 2012 Posts: 1,021	95% Topps 4% Panini 1% Leaf Since I mainly just collect cam's chrome cards, I deal mostly with topps. I will randomly buy a different company's cards, if I see something I like. Sorry, but I wish I had a pie chart to visualize my cards. Good job on yours OP, looks good. __________________ Looking for 2011 Cam Newton Chromes and the 2012 Newton Chrome Superfractor. Last edited by frankhoover; 02-08-2013 at 05:10 PM.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

02-08-2013, 04:38 PM	#2 (permalink)
bktochi4 Member Join Date: Feb 2013 Location: Chicago Posts: 39	I do have mine in excel - how did you make that? haha.

02-08-2013, 04:49 PM	#4 (permalink)
bktochi4 Member Join Date: Feb 2013 Location: Chicago Posts: 39	Next dumb question: Now that I have the chart, how do I post it into this?

02-08-2013, 04:58 PM	#6 (permalink)
bktochi4 Member Join Date: Feb 2013 Location: Chicago Posts: 39	I like pie - but for whatever reason, I am technologically challenged today. My data, however, is as follows: Topps: 60% Other: 5% Panini: 21% Sage: <1% Upper Deck: 14% Just visualize the pie.