+ Reply to Thread
Results 1 to 5 of 5

Pivot table showing the wrong data, how can I select the columns I want?

  1. #1
    Registered User
    Join Date
    10-22-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    2

    Pivot table showing the wrong data, how can I select the columns I want?

    Hi,

    I have a pivot table that has 4 columns. 2 of them are percentage columns, and 2 of them are number columns. Each percentage column corresponds to a number column. When I try to create a chart, it doesn't let me see the percentages, only the numbers. I would like the Y axis to be percent (0-100%), and the X column to be the Rows in my pivot table. Please see the attached image. Any ideas??

    pic.png

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,680

    Re: Pivot table showing the wrong data, how can I select the columns I want?

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,680

    Re: Pivot table showing the wrong data, how can I select the columns I want?

    Administrative Note:

    Hi and welcome
    although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile to something more precise then "World" ( country will suffice, no need to be more precise).
    Thank you for helping us to help you

  4. #4
    Registered User
    Join Date
    10-22-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    2

    Re: Pivot table showing the wrong data, how can I select the columns I want?

    The data set is huge and I don't have the time to create another workbook just for the purpose of providing a sample. I would think if someone knew the answer to my question, they could answer without the need for a file or image even. From reading online, it seems you cannot hide unwanted columns from a chart... but then I would at least want to select which metric to use for the Y axis. Everything that is required to answer my question is available in the first post. Thank you.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: Pivot table showing the wrong data, how can I select the columns I want?

    the mixture of percentages and integer values on the same axis is causing the problem. Percentages would be a value been 0 and 1. Your integer data forces the scale to be 0 to 8000. even 100% would be invisible.

    Move the percentages to the secondary axis.
    If you leave the percentages as columns then you will have the 2 columns in front of each other, so change them to line chart type. You will still have the problem that the lines data points will be positioned between the columns rather than centered over each column.
    Cheers
    Andy
    www.andypope.info

+ 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. Multiple pivot charts showing different data for same pivot table
    By gwood97 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2019, 06:07 PM
  2. Replies: 5
    Last Post: 08-29-2018, 11:17 AM
  3. Pivot Table Showing Wrong data
    By fuerte in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-18-2018, 12:21 PM
  4. [SOLVED] Can I add a row showing percentages to pivot table columns?
    By tuph in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-17-2016, 05:10 PM
  5. Pivot table showing / comparing information from multiple columns
    By NiranNiran in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-25-2015, 11:00 AM
  6. Pivot table showing wrong data (date not month)
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 06:59 AM
  7. Replies: 2
    Last Post: 12-25-2008, 08:13 PM

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