My filter for my pivot table is in cell A2 and it's a value for a store number. I have a pivot chart tied to the pivot table. When I filter by store# (i.e. store# 300), how do I get the pivot chart to
I have a pivot table that displays names in descending order. The corresponding pivot chart displays the names in ascending order. Whenever I change one, the other sorts in revrese order. How do I get
In one workbook, I have multiple pivot tables driving various charts. I just copied a pivot table (so I could change the field information & create a new chart) & when I created the chart, it pulled
I am attempting to create a pareto from pivot table data. I want the chart to be in a stacked form, also. So the natural progression would be pivot table data to stacked chart to pareto. I've been
I have a pivot table chart with a primary and secondary axis. When I change a variable in the pivot report filter, the X axis disappears from the chart. The only way to restore it is by creating a new