Create a Chart in Access 2007

Access tables store lots of raw data such as contact names, sales figures, prices, salaries, gender, etc. Numbers are great for calculation but they are not ideal when you need to describe the data to another person. Charts and graphs which summarize data visually, enable us to communicate data value and trends not only for ourselves, but also for inclusion in a business report.

Follow the steps below to build a new chart in Access:

1. Open a blank form in Design view.
2. If necessary, click the Design tab.
3. Click the Insert Chart button.
4. Drag the mouse pointer to define the chart’s area.
5. Select the option button to display your database’s tables, queries or both.
6. Click the table or query to provide chart data.
7. Click Next.
8. Click the first field to add to the chart.
9. Click the Add button.
10. Click the chart type you would like to insert.
11. Click Next.
12. Verify that the chart appears the way you want and then click next.
13. Key in a name for your chart.
14. Select the option button that reflects whether you want to display a legend or not.
15. Click Finish.

You an see what your chart will look like by using the Preview Chart button at the top left of the Wizard page.