The Default View Property text box and select PivotChart from the drop-down (period) until you reach the Form's Design ![]() Show/Hide tab and clear the FieldButton/Drop Zones General tab and select Title from the drop-down list.įormat tab and enter 2005 Total Sales Per Employee. General tab and select Value Axis 2 Title.įormat tab and enter Employee in the Caption text box. General tab and select Value Axis 1 Title from the drop-down list.įormat tab and enter Total Sales in the Caption text box. ![]() The Properties tool in the PivotChart toolbar. The Order Year button and clear all check boxes except for 2005. The Order Total field to the Data drop zone. The Order Year field to the Filter drop zone. The Employee field from the Chart Field List to the Category drop zone. The Employees_and_Orders query from the drop-down The database window under Objects, click Forms. Query includes four fields: Employee, Order Month, Order Year (2001 throughĢ006), and Order Total. Query that lists the employees and their total orders by month and year. Then add it to the employees' sales report. You can create a pivot chart that compares employees' sales data for 2005 and ![]() YouĬan also distribute your pivot table analysis in a printed report. Pivot charts in Access are not just for display only.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |