As the title states, is this possible? I googled pretty much the same terms as the subject title and was unable to find anything close to my issue. I have around 20 columns and wanting to show total as percentage of column and it's cumbersome to do one column at a time. Any suggestions?
Thanks for the reply Jason. After I click on the third slicer, the original bar chart is still there with the primary axis in tact. The secondary axis is cleared and I cannot see the line chart that was there. Avg price is there, but not as a secondary axis so it is not visibile.
How do I...
hello fellow Excel gurus. I have been stumped for weeks now trying to figure this problem out. In Excel 2010, I have three slicers connected to a pivot chart. It is a bar chart based off of units sold and avg price of the unit across 52 week periods. Weeks are on the X axis, and I add a...