Very Specific Spreadsheet Question: Ranges
June 19, 2012 5:19 PM Subscribe
How do you make Excel automatically group years (1921, 1925, 1929) into decades (1920s)?
posted by goatdog to Computers & Internet (7 answers total) 3 users marked this as a favorite
Spreadsheet has two columns: (A) year and (B) books published that year on a particular topic. (A) is a four-digit year, and (B) is bibliographic info on a single book. I need to do a graph that will show how many books that I'm tracking were published by decade.
I can do a pivot table to give me counts of these books published each year. However, I don't know how to make it group by decade: a graph (pie chart, etc.) that will take the counts for 1912, 1916, 1917, and 1919 (not every year will have a count); total them; then output something visual.
I'm so baffled I don't even know what to search for, so even providing me with the correct terminology so I can find it myself would be a great help. I'm doing this in Excel.