Results 1 to 5 of 5

Pivot: organizing data in colums

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Helsinki, Suomi
    MS-Off Ver
    Excel 2007
    Posts
    2

    Pivot: organizing data in colums

    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
    Last edited by Villu; 12-03-2013 at 05:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table for organizing cost as a % of total per month
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-17-2013, 04:49 PM
  2. Help with organizing data-pivot table
    By putitwhere in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 04-30-2013, 08:18 PM
  3. Difference between colums in pivot
    By IM2HARD2RESIST in forum Excel General
    Replies: 2
    Last Post: 10-15-2009, 11:25 AM
  4. Help organizing data using Pivot Table
    By Branden in forum Excel General
    Replies: 0
    Last Post: 03-21-2006, 02:55 PM
  5. pivot table - two colums of data are missing
    By JJ in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1