How to Create a Chart in Access 2003
Charts or graphs are created in or added to reports and forms in Access 2003. Charts provide a graphical representation of your data, enhancing the visual appeal and aiding understanding of the data presented. Microsoft Access 2003 has the following types of two-dimensional charts available: column, bar, line, pie, scatter, area, doughnut, radar, surface, bubble, stock, cylinder, cone and pyramid. The column, bar, line, pie, area, surface, cylinder, cone and pyramid are also available as three-dimensional charts.
Other People Are Reading
Instructions
-
Create a Chart in a New Form or Report
-
1
Open Microsoft Access 2003. Click "File" and "Open" from the menu bar. Highlight the database and click the "Open" button. Select "Reports" or "Forms" from the "Objects" pane. Click the "New" button in the toolbar of the "Database" window.
-
2
Highlight "Chart Wizard." Select the table or query, which contains the data for the chart, from the drop-down box. Click the "OK" button. Select the fields to include in the chart. Click the ">" button. Click the "Next" button.
-
-
3
Choose the type of chart by clicking on the pictorial representation on the left side of the window. Click the "Next" button. Click and drag the field buttons on the right side of the window to the sample chart to design the layout. Click the "Preview Chart" button to test the layout. Click the "Next" button.
-
4
Type a title for the chart under "What title would you like for your chart?" Choose the radial button to specify if a legend is displayed. Select to "Open the report (or form) with the chart displayed on it." Click the "Finish" button.
-
5
Click "File" and "Save as" in the menu bar. Type a name for the report in the "Save as" window. Click the "OK" button.
Add a Chart to an Existing Form or Report
-
6
Open Microsoft Access 2003. Click "File" and "Open" from the menu bar. Highlight the database and click the "Open" button. Select "Reports" or "Forms" from the "Objects" pane. Right click on the name of the report or form to which you will add the chart. Select "Design View" from the menu.
-
7
Select "Toolbox" from the "Form Design" toolbar. Right-click on "Toolbox." Select "Customize" from the menu. Choose "Toolbox" from the "Categories" pane on the "Commands" tab. Click on "Chart" in the "Commands" pane. Drag the "Chart" icon to the "Toolbox." Click the "Close" button in the "Customize" window.
-
8
Click the "Chart" button in the "Toolbox." Click in the area of the report or form where you want to place the chart. Click "Both" under "View" in the "Chart Wizard." Select the table or query that you want to use in your chart from the white pane. Click the "Next" button.
-
9
Select the fields to include in the chart. Click the ">" button. Click the "Next" button. Choose the type of chart by clicking on the pictorial representation on the left side of the window. Click the "Next" button.
-
10
Click and drag the field buttons on the right side of the window to the sample chart to design the layout. Click the "Preview Chart" button to test the layout. Click the "Next" button.
-
11
Link the form fields to the chart fields using the drop-down boxes. Click the "Next" button. Type a title for the chart under "What title would you like for your chart?" Choose the radial button to specify if a legend is displayed. Click the "Finish" button.
-
12
Click "File" and "Save" in the menu bar.
-
1
