+ Reply to Thread
Results 1 to 2 of 2

Pivot Chart not showing right values

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    San Francisco
    MS-Off Ver
    Windows 7 professional
    Posts
    29

    Question Pivot Chart not showing right values

    Hi I am doing a pivot chart however as you can see in the picture some of the bars have the same Y value but they have different heights and also the y axis I have repeated values. So the graph appears weird. Can you please help. How can I solve this problem?

    Capture1.PNG

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

    Re: Pivot Chart not showing right values

    Difficult to say from the picture, but I notice that your Y axis appears to be formatted "0" with no decimals, so there are two gridlines labeled 98% (I would guess the lower one is actually 0.975 and the upper one is 0.980). Same for 99% and 100%. I would guess that your data labels are also rounded to the nearest hundredth (integer per cent), but that the actual values being plotted are more precise. You need to look at your data and determine the exact value being plotted for each column, because I suspect that what you believe is the same value is not actually the same value.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Showing Grand totals in a pivot chart
    By i82 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-13-2016, 03:17 AM
  2. Not showing 0(zero) values in a chart.
    By scottishmac in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-17-2015, 04:48 AM
  3. Chart Source values showing as zero in chart
    By Bernieboo62 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-29-2014, 10:53 PM
  4. [SOLVED] Pivot chart filtered showing subtotal
    By Eemmai in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-05-2012, 05:57 AM
  5. Replies: 4
    Last Post: 03-05-2010, 02:04 PM
  6. [SOLVED] Preventing NULL showing as 0 on a pivot chart using Office Web Component.
    By lk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-13-2005, 11: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