There are two types of changes you can make when editing a chart: cosmetic or data.
Cosmetic changes include changing the size of the chart on the form or report, or changing the appearance of the chart with Microsoft Graph, such as the location of its parts, the text format, the colors and patterns, and the axis scaling.
Data changes include modifying the underlying table or other record source, or the query in the RowSource property.
When you use the Chart Wizard to create a chart that displays data from Microsoft Access, you choose the table or other record source that includes the fields that are displayed in the chart. This underlying table or other record source contains the data, such as sales figures or customer lists. After you have finished making selections in the Chart Wizard, Microsoft Access creates a query in the RowSource property, which is based on the underlying table or other record source. The query in the RowSource property reflects the choices you made in the Chart Wizard to restrict the data, such as a range of dates or orders from a specific region.
For example, if you notice that the sales figures in your chart are wrong, the problem may be in the data stored in the underlying table, or in the design of the underlying record source. In this case, correct the underlying table or other record source. However, if you left out a field that you want to appear in your chart, either you can use the Chart Wizard to create the chart again or you can edit the query in the RowSource property.
Change the appearance of the chart
Change the data in the underlying table or other record source
Customize the format of a chart