Home |
Search |
Today's Posts |
#1
|
|||
|
|||
chart the number of occurances
Hey all,
I'm creating a database of my music albums in excell, in addition to album title and performer, I also store the album year, from wich country..... Now i'd like to make stats of this: e.g. a column chart with on the X-axis years, and on the Y-axis the number of occurances (=the number of albums) from that year. Can anyone help me? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart the number of occurances
Hi, Use a pivot table /pivot table chart..should be fairly easy Data Pivot tables... -- Richard Flame ------------------------------------------------------------------------ Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944 View this thread: http://www.excelforum.com/showthread...hreadid=557813 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
count number of occurances of a word in a range | Excel Worksheet Functions | |||
count duplicates/total number of occurances | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel |