Pivot Table View - Multiple Charts

G

Grd

Hi,

I have a Pivot Table View based on a query and I have the option set to show
multiple charts.

So I get a chart for each SalesPerson. By placing the SalesPerson field in
the Drop MultiChartFields here.

I place Customer in the Category field and Sales in the Data field.

I'm getting all Customers on each chart - not just the ones that each Sales
Person is responsible for which is what I want.

Am I doing something wrong? I can't see to get it to work- any help would be
greatly appreciated

Tx
Suzanne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Pivot Chart in Access Form not working 0
Excel 2013 Copying pivot charts to PowerPoint 0
Dealing with a Pivot Table (when I don't want to) 0
Multiple Pivot Charts to display in one page 0
Pivot Table Comparison 0
Pivot Table showing wrong data 1

Top