+ Reply to Thread
Results 1 to 3 of 3

Pivot Chart Inaccuracy

  1. #1
    Forum Contributor
    Join Date
    05-23-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    262

    Pivot Chart Inaccuracy

    Hi Everyone,

    I have a dashboard that uses multiple pivot tables but can't figure out why a few of the bar charts show data in such a misleading way.

    For example, the following single bar chart:

    PT.JPG

    The ratio of those numbers is around 13.5% of the total inspections required but the bar shows it closer to 80-85% complete. Is there a way to get a pivot bar chart to more accurately display the ratio between the bars (I'd like it to show the counts as it does now, but to have the red shaded area more accurately reflect what it should).

    Is this possible?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,482

    Re: Pivot Chart Inaccuracy

    I'm sure it is possible, but it is going to be difficult to debug a picture. My first guess is the the numbers given in the data labels are not the same number as what is plotted. The first debugging steps I would likely follow:

    1) Select the red bar and identify what range it is pointed to. See what value is being plotted.
    2) Select the gray bar and identify what ranges is pointed to. See what value is being plotted.

    If either of those values do not match the data label, then figure out why. If they do match, then dig deeper to figure out why they seem so obscured (look at chart type, axis type, and so on).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,039

    Re: Pivot Chart Inaccuracy

    It may also be that one series is plotted on a secondary Y axis with a different scale.

+ 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. Replies: 0
    Last Post: 07-29-2015, 09:41 PM
  2. Chart order in trad. Pivot Chart vs. PowerPivot chart
    By mr_jules in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-06-2015, 11:17 AM
  3. Changing a pivot chart column color based on the pivot table category
    By Shawne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2014, 09:12 AM
  4. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  5. Replies: 2
    Last Post: 05-24-2013, 03:58 PM
  6. Replies: 3
    Last Post: 09-11-2010, 06:55 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