+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Data Formatting

  1. #1
    Registered User
    Join Date
    06-07-2020
    Location
    brooklyn
    MS-Off Ver
    2005
    Posts
    1

    Pivot Table Data Formatting

    Hi Excel forum users - this is my first post so please excuse any breaks in etiquette or basic questions

    I have a table of chemical results that I would like to generate graphs for, eventually to find meaningful correlations

    So far I have re-organized the data into vertical columns, since that appears to be necessary for pivot table setup. Even so, when I click 'insert pivot table' and select the area of the table in the dialogue box I get the following message (paraphrased):

    "The Pivot table Field name is not valid'.. 'you must use data that is organized as a list..'

    So far the tutorials I have checked do not make any issues with the format of the data clear to me. A photo of the table is below. My goal is to compare two columns, with one or more data series.

    Thanks in advanced for any help

    Pirvot 1.JPG

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    844

    Re: Pivot Table Data Formatting

    Hi erkvos,
    It is always better to attach a sample file (cleared of any confidential data) for members to work and try a solution to your question. Screenshots show a picture, but no real insight in the structure of the data.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,854

    Re: Pivot Table Data Formatting

    You've got some hidden columns in that picture. Are any of the headers in those columns blank?
    Rory

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Pivot Table Data Formatting

    To follow ORoos's advice see the yellow banner for adding sheets

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table - formatting data shown
    By maitehar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-23-2015, 12:02 PM
  2. Replies: 2
    Last Post: 09-04-2015, 02:47 AM
  3. formatting source data for a pivot table
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 04-02-2014, 05:27 PM
  4. Replies: 0
    Last Post: 02-20-2014, 11:49 AM
  5. Pivot Table (extracted data from pivot, in source formatting)
    By nsumitg in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-06-2013, 08:55 AM
  6. formatting data for pivot table
    By shawzito in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 10-17-2010, 03:30 PM
  7. Update data but keep pivot table formatting
    By Racer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2010, 12:58 AM

Tags for this Thread

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