Setting the recordsource for a pivot chart

[Guest]

I am trying to use a pivot chart in the front end of a spit Access database
that displays data from the back end. I would like to use a client side
recordset as the source of data for the chart but can't seem to get past
first base. Can anyone help me with details on how to set up a pivot chart
in VBA, particularly how to reference data for the chart from a recordset.

 

[Guest]

Hi Stu,

Have you tried using the wizard? It walks you through the steps.

Or, you can do the following:
In form design view, place all the fields that you want to use from the
table or query on the form.
go to the menu view-pivot chart
then drag and drop the fields where you want them.

Just because it took me a while to find this, use the right click-properties
to customize the colors, titles, data lables, chart type, etc... each
different area on the chart has it's own set of properties to play with...

Hope this helps.