+ Reply to Thread
Results 1 to 2 of 2

Pivot table grouping numbers that I do not want them to group

  1. #1
    Registered User
    Join Date
    07-13-2010
    Location
    Washington, DC
    MS-Off Ver
    Excel 2007
    Posts
    4

    Pivot table grouping numbers that I do not want them to group

    Okay so I have a column of numbers as a field in a pivot table (board names). I am trying to figure out a way for the pivot table to treat each row of data as absolute. The problem is when I use the board names as a field in the pivot table, it groups these board names together and it messes up the integrity of my chart. So for instance board name: 123456 may appear 7 times in my data set, however when I go to make a chart about those 7 different boards, it recognizes them as the same thing. So my question is how do create a chart on the pivot table that will allow to put my board name field on my chart without excel grouping the board names together?
    Last edited by atmosphereee; 07-16-2010 at 04:11 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Pivot table grouping numbers that I do not want them to group

    Hard to say without seeing your layout and knowing what's in the other columns. If you have a column (or set up a column where each board name is in a different division and then move that column to the row pivot table first followed by the board name, they will be treated separately.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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