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.