Pivot Chart in Access Form not working

G

Grd

Hi,

I have a Pivot Table View in a form. The form based on a query and I have
the option set to show multiple charts on the Pivot Table view. So I have
many charts (about six) not just one.

The idea is to show a chart for each sales person showing their sales of
various products. I can get a chart for each SalesPerson by placing the
SalesPerson field in
the Drop MultiChartFields here - thats not a problem. I place the
SalesAmount field into the Data area to get my chart.

However I need it broken down by product so I placed the Product sold into
the Category field however when I do this I'm getting unexpected results.

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

Is this how its supposed to work? It doesn't make sense to me. If I can get
this to work I will be very happy indeed. (I want to restrict the products on
each chart to the ones that that salesperson sold.)

Thanks for any help
 

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
Unreadable text when viewing organization chart in Web version of Visio 365 0
Filtered view of Visio Chart 0
Create a chart from a table in word thats dynamic 0
Move Chart with Text 0
Creating a Chart on form from selected data in query. 0
Optionbutton Not working 3
Excel 2013 Copying pivot charts to PowerPoint 0

Top