So I'm trying to make a Pivot Chart out of this: Housing BIG DATA english.xlsx
The chart is originally in finnish but I translated the beginning just so you can understand what I'm doing. Basicly its a chart about Finnish housing. On the left there is the county starting in Alphabetical order ''Akaa, Alajärvi.'' Then how many 1,2,3,4,5,6,7+ people single-family houses, terraced houses, block of flats and other houses there is in the county.
I'm trying to make a Pivot chart that could would have various information in it e.g. ''how many single-family houses are in these specific 232 counties and the percentual amount compared to all housing in these 232 counties.''
The problem is as I'm trying to create the Pivot chart Excel says: '' To create a Pivot Table you must data that is organized as a list with labeled columns.'' Simple enough, but still as an amateur user I'm not able to figure out what should i do exactly.
So if someone could organize or instruct me to organize the first county so that it is Pivot compatible, I would appreciate it greatly! Thanks in advance!
Ps. My description of the problem is probably vague and wrong but if you look at the chart you'll propably easily see what the problem is.
E: my MS Office version is 2010
Bookmarks