+ Reply to Thread
Results 1 to 3 of 3

Problem with how data is visualised in PivotChart

  1. #1
    Registered User
    Join Date
    09-13-2016
    Location
    Warsaw, Poland
    MS-Off Ver
    2019
    Posts
    32

    Problem with how data is visualised in PivotChart

    Hi guys,

    I have a problem with my PIVOT chart. For some reason it visualises data incorrectly in relation to each other.
    What I mean is, I have a line chart, I've linked a printscreen below (I had trouble with posting an image within text...), which has 4 lines for 4 categories. As you can see for example in Jun the orange line says "-1129.81" while the yellow and grey ones beneath both are much higher values "-191,97" and "-254.29" respectively. Why is it that in this chart the orange line is above the other two? It's like with all other months as well. The point of this chart, for me, was to compare the data between those lines, but when they show like this, it's completely useless.

    (Dropbox) PIVOT Chart

    I'm attaching the file as well, it doesn't really have any confidential data...

    Thanks for your help,
    Nina
    Last edited by Nina579; 07-13-2020 at 02:13 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Problem with how data is visualised in PivotChart

    As near as I can tell, it looks correct for the chart type you chose -- a stacked line chart. Did you intend to use a stacked line, or did you actually want a regular line chart?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    09-13-2016
    Location
    Warsaw, Poland
    MS-Off Ver
    2019
    Posts
    32

    Re: Problem with how data is visualised in PivotChart

    ... I'm so embarrassed right now. Of course I didn't mean to use that chart type. Thank you for pointing this out. OTL.

+ 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. Problem copying PivotChart from Excel to PowerPoint
    By quinnj09 in forum Excel General
    Replies: 1
    Last Post: 07-20-2017, 07:04 AM
  2. Hide data without removal in PivotChart?
    By alexpsyched in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-14-2014, 12:10 AM
  3. PivotChart filtering and chart type problem
    By php219 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2007, 03:55 PM
  4. [SOLVED] I cannot get my pivotchart to filter data the way I want
    By jpgrimes22 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2006, 03:40 PM
  5. Replies: 0
    Last Post: 10-16-2005, 08:05 PM
  6. PivotChart Data Field - can it be value?
    By pajordan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-12-2005, 01:06 AM
  7. How do I change how PivotChart data is summarized, from sum to av.
    By csavage in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2005, 01:06 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