Add a new chart to a form or report

1. Open the form in form Design view or report in report Design view.
   
   
2. Click Chart on the Insert menu.

   Tip   If you create a lot of charts, you may want to add Chart to the toolbar.

   How?

3. On the form or report, click where you want to place the chart.
   
   
4. Follow the directions in the Chart Wizard, which creates the chart based on available tables or other record sources and the fields you select.

   Note   At least one of the fields must have a data type that stores only numbers, such as Currency.

5. Switch to Form view or Print Preview to see the chart with current data.

Notes

• In a Microsoft Access project, you can't use the Chart Wizard, but you can add a chart by inserting the Microsoft Graph 2000 Chart object (Insert menu, Object command).
  
  
• In form or report Design view, the chart shows sample data when you first create it. To see current data, switch to Form view or Print Preview, or close the form or report and then open it. Learn about customizing a chart.
  
  
• The Chart Wizard creates a query for the record source in the RowSource property, which reflects the data restrictions that you specified when you filled out the Chart Wizard dialog boxes. If the chart doesn't look the way you want it to look, click .
  
  
• You can't create a radar, surface, or combination chart by using the Chart Wizard. However, in Microsoft Graph you can change the chart you created with the Chart Wizard to any chart type, including a radar, surface, or combination chart. Learn about using Microsoft Graph.