+ Reply to Thread
Results 1 to 2 of 2

Pivot Table turning out oddly

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    Kelowna, BC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Pivot Table turning out oddly

    Hello,

    I'm hoping someone will be able to help with this. I've been tasked with creating a pivot table for spreadsheet with TONS of data (15 columns, 235,000 Rows approx).
    When I make the pivot charts, the charts appear to look odd. The data on the new page all seems to be correct (this is a guess, obviously). The chart, however seems have rearranged the data. The chart fluctuates up and down violently in a way that is not actually possible (see attached picture).

    Was wondering why this was the case, if you have any suggestions. Capture.JPG

    Let me know if you need any additional info.

    I am using MS Excel 2010.

    Thanks,

    - Eddie

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Pivot Table turning out oddly

    my best guess is the chart reflects the data in your table. I suggest you look at the data. has the pivot table changed the order of your data?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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