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 secondary axis for avg price, which is a line chart. When I choose an item from the first two slicers (slicer values are customer name and product category), the chart updates the avg prices and unit amounts just fine and in tact. As soon as I choose a selection from the third slicer which has the product items listed, the secondary axis line chart formatting is reset and removed. I know this is not very clear, so I can send my file over if anyone would like to see. Thank you much!!!
Excel 2010 Slicers and Charts - NEED HELP PLEASE!(3 posts) (2 voices)
once you select an item from the 3 slicer, what does your pivot table look like? is there still a 'avg price' for that unit across the 52 week period? if not, then that would be why the line disapears. if all the needed data is still present in the Pivot Table and it just 'disappears' then posting the sample spreadsheet may be a good idea.
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 attach a spreadsheet here? I can email to you if that helps.
You must log in to post.