Take Control: Producer Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Excel and Access

Microsoft Excel is also part of an integrated solution. Microsoft Access has an excellent PivotChart function that lets you visualize your data.

 

Try it: Create a PivotChart

Open the Front Row Video database.

Select tblMovieTitles.

Go to Create->PivotChart.

 

 

You should see a new form with a blank PivotChart. You may not see the fields.

If not, go to Design ->Field List.

 

Drag the following fields onto the Chart:

Data: CountofMovie. 

Series: Rating

Create->PivotChart