Excel 2010 Pivot table

Posted on 2011-04-27
Last Modified: 2012-06-27
I want to show my values vertically instead of horizontally in the pivot table.
Thank you
Question by:darlene_shepherd
    LVL 39

    Expert Comment

    Move the column field to the row field, as in the attached screencast

    LVL 85

    Accepted Solution

    If you are talking about the data values, right-click the Values header and choose Move Values To - Move Values to Rows.
    (If you don't have the Values row visible, right-click the table, choose Pivot Table options, on the Display tab, check the option to show the Values row.)

    Author Comment

    It doesnt show up exactly like that for me - it may be because I didnt say i was using olap cube.  Your answer may be right though - I moved a tag named values from the column label area  to the row labels area.   However I have a bunch of values in my values area. It was this tag that wasnt clear to me. Thank you.

    I dont think your solution would work If you had more than one value.
    I am giving it to you anyway because I am not sure.

    Author Comment

    Roryr's solution is exactly correct.
    LVL 24

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now