+ Reply to Thread
Results 1 to 1 of 1

Multiple Columns in Pivot Table (but don't show in Pivot Chart)

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    Southern Indiana, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Multiple Columns in Pivot Table (but don't show in Pivot Chart)

    Hi All!

    I'm creating a pivot table that feeds data into a pivot chart and it's all working just fine-- thanks to some earlier help I got on this forum! ...but I now have have another question.

    In my pivot table, I want to have multiple value columns displayed in the table. However I only want one of the value columns to be displayed in the related pivot chart (and not all of the value columns).

    I tried looking for a way to change the data source for the chart and various properties of the value column, but don't see anything.

    Is there a way I can do this? I can provide screenshots or an example file if that's helpful...

    Thanks!

    PS: question also posted at http://www.mrexcel.com/forum/showthr...64#post3128264.

    [Potential Solution]

    I think I figured it out...

    So, after I add my second column to my pivot table, I select the series in the chart, and change it to plot on the secondary axis. Then on both the vertical and horizontal axis options for my series, I chose to not display them. (In my pivot chart, this new series showed up multiple times for each unique value, so I had to repeat this process multiple times for each value to "hide" the series in the chart).

    At this point, I still had the series I wanted to hide showing up in the legend, so I deleted each of them.

    It took a few steps to get it right and hopefully my chart format won't reset if I refresh data or do other minor tweaks to the pivots, but it looks good so far.

    I may end up painting myself in a corner if I have to eventually have a "real" secondary axis, but I'll deal with that later, I guess...
    Last edited by Gideon1973; 04-23-2012 at 01:53 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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