Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Feb 25, 2013, 06:29 PM   #1
Tumbleweed666
macrumors 68000
 
Join Date: Mar 2009
Location: Near London, UK.
Seeking Numbers help. Pie chart & classifications

Not sure where to start with this one, so i thought I'd outline the problem and see if anyone has a solution.

Lets say I have a list of stocks,and each stock has attributes such as name, value, geography, risk etc

I might have

Stock Name Value Geography Risk Type
Stock A 50,000 Europe High
Stock B 25,000 Europe Medium
Stock C 75,000 USA Low
Stock D 80,000 Asia High

Is there a way to use Numbers to display various pie charts, eg not just stock names vs value, but also showing, for example, the breakdown, on a value basis, of high, medium and low risk stocks, and stocks in different geographies, without me needing to add it all up manually?

Or do I need a database to do this kind of operation?

TIA
__________________
27" late 2013 iMac, 16 GB RAM, 512 GB SSD, OSX 10.9.2
Tumbleweed666 is offline   0 Reply With Quote
Old Feb 26, 2013, 08:45 AM   #2
Tumbleweed666
Thread Starter
macrumors 68000
 
Join Date: Mar 2009
Location: Near London, UK.
Answering my own question, use table categories, sort of a mini-pivot table.
A very nice explanation here http://macmost.com/pivot-tables-in-i...9-numbers.html
__________________
27" late 2013 iMac, 16 GB RAM, 512 GB SSD, OSX 10.9.2
Tumbleweed666 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Numbers - Hide chart source/table? TonyC28 Mac Applications and Mac App Store 1 Jun 14, 2014 04:23 AM
Numbers vs Excel when mixing text & numbers TheBlackLabEdge Mac Applications and Mac App Store 5 Mar 6, 2014 09:29 PM
Pages & Numbers Folders BetsyMePoocho iCloud and Apple Services 0 Oct 31, 2012 10:42 AM
AT&T order numbers not showing up anywhere lilthrift iPhone 0 Sep 17, 2012 08:29 PM
New Game Released] Mr. & Mrs. Cutie Pie available on iOS App Store Aimeejoy iPhone and iPod touch Apps 0 Aug 29, 2012 02:48 AM

Forum Jump

All times are GMT -5. The time now is 11:10 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC