Multiple Columns in Pivot Table (but don't show in Pivot Chart)
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...
PS: question also posted at http://www.mrexcel.com/forum/showthr...64#post3128264.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1