create pivot chart from pivot table

[dharkangel]

Hi,

I have just created a pivot table in a data access page. Is there any way to generate a pivot chart from this like the way you can in Excel??

 

[fneily]

If you have 2002, probably the same for 2003, try these steps.
Create a DAP. Click the Office Chart button in the toolbox. Click on the page to create the chart. A PivotChart layout should appear. Click in the layout to open the Commands And Options box. Under Select where the chart comes from, there are three choices. Pick one. The Data Details and Types tabs appear in the box. You can then choice what type of chart and whether to plot details. Close the box and you should see your chart.