While data analysis as we have seen so far was performed on records displayed on datasheets or forms, data analysis on charts is done using graphics that present pictures. In addition to the pictures, you can add words, also called labels to indicate what the pictures represent.

Because a chart is used to present data in a graphical format, before creating a chart, you should plan it. That is, you should prepare it. There are two pieces of information you should have before starting: The numbers that you want to represent and the type of chart you want to use.

The information used to create a chart can come from a table. In some other cases, you can use a query as queries do a good job of isolating records or counting them. Before creating a chart, you should prepare it so it can be easily recognizable. Data used on a chart can be made of natural numbers or percentage values. You can also present a series of repeating words and let the chart engine count the occurrences of such words before using them as numbers.

To start a chart, display a new form or report in Design View. In the Controls section of the Ribbon, click the Chart button . Position the mouse on the form or report. The mouse cursor would appear with small bars:

You can then click the form or report. This starts the Chart Wizard and you can continue with it.

There are different types of charts, ranging from columns to pies, from lines to surfaces, etc, as we will review them. To present its information more efficiently, a chart is made of different sections. The main area allows users to view the graphical display of data. A legend explains the meaning of various colors on the chart. A title indicates what the chart is used for.

1. Start Microsoft Access
2. From the resources that accompany our lessons, open the Altair Realtors2 database
3. On the Ribbon, click Create
4. In the Forms section, click Form Design
5. On the Ribbon, in the Controls section, click the Chart button
6. Click the form
7. In the first page of the Chart Wizard dialog box, make sure the Tables radio button is selected and, in the list, click Home Sales
    
   
    
   Click Next
8. In the second page of the Chart Wizard, in the Available Fields list, double-click State to include it in the Fields For Chart list
9. Click Next
    
   
10. In the third page of the Chart Wizard, accept the Column Chart in the 1st column - 1st row and click Next
     
    
11. To preview the chart, click the Preview Chart button
     
    
12. Click Close and click Next
13. Set the Title to Sales Per State
     
    
14. Click Finish
15. To save the form, click the Save button
16. Set the name to Sales Per State
17. To preview the chart, display the form in Form View
     
    

A chart cannot reside on its own: it needs a container such as a form or a report. This also implies that the chart can only fit inside the size allocated by its host. Based on this, if the database is configured to display in Overlapped Windows, and if you want the chart to be taller or wider than the size it currently has, you must first display the form or the report that is hosting it in Design View, and then enlarge the host. Once the parent object has enough room, you can enlarge the chart as you see fit. If you are creating the chart on a report and if the chart needs room, you can enlarge the report, then enlarge the chart and set the page setup to Landscape.

1. Display the form in Design View
2. Widen the form to 6.1
3. Heighten the Detail section to 4.1
4. Enlarge the chart to 6 and heighten it to 4
    
   
5. Save the form

To present its information, a chart is made of various sections:

Most or every one of these aspects can be hidden, displayed, or changed. To perform any action on these parts, after displaying the form or report that holds the chart in Design View, you use Microsoft Graph. To open it:

• You can right-click the chart, position the mouse on Chart Object and click Open
• You can double-click the chart

This would open a separate application:

In Microsoft Graph, you can click or right-click the desired part.

As mentioned already, to create a chart in Microsoft Access, you use values from a table or a query. When analyzing data using a chart, you may want to use "What If" scenarios. For example, if you are viewing the numbers of students per gender in a school and one gender is predominant, you may want to view the tendency if the number of members were the same for both members, if the members of the predominant gender were even more, or if the members of the other gender were predominant. Therefore, during data analysis, you can change the values used by the chart. When you have finished using the chart and you close its parent, the values you used would be lost and the chart would again use only the values stored in its Row Source.

To change the values used for a chart without changing the real values, you can open Microsoft Graph. It would present a spreadsheet:

To change the value, in the Datasheet, click the cell that holds the value and type the desired one. After editing the value(s), click the body of the form or report to return to Microsoft Access. The chart would display with the new values. Remember that if you close the form or report, the chart would loose those temporary values.

To show what the graphics on a chart represent, a chart is accompanied by an object on a side called a legend. The legend is made of at least one small square box of the same color of at least one of the graphics on the chart:

In this case, the legend contains one item named Count. Because the legend represents a graphic of the chart, when you make a change on that graphic, the legend is updated. Still, you can change the legend if you want.

To make changes to the legend, display the Microsoft Graph for the chart, right-click the legend and click Format Legend. This would open the Format Legend dialog box, make the changes, and click OK.

If you do not want to use a legend, you can delete it. To do this, right-click the legend and click Clear or click the legend and press Delete.

1. Right-click a white area of the chart, position the mouse on Chart Object and click Open
2. Right-click the box with Count and click Format Legend
3. In the Format Legend dialog box, click the Font tab
4. In the Font combo box, select Garamond
5. Click the Color combo box and select Red (1st section: 1st column - 3rd row)
    
   
6. Click OK
7. Close Microsoft Graph

To indicate what it is used for, a chart can be equipped with a title. The title is a string that typically displays in the top section of a chart. In some (rare) cases, a title can also be positioned on the left or the right sides, above or below the chart. To move the title, display the form or report in Design View, click and drag the chart in the desired direction.

To format the title, you can either double-click it or right-click it and click Format Chart Title. By default, the chart displays without a border and in bold Calibri font. You can change or format it using the Format Chart Title dialog box.

When creating the chart, if you need more room for it, you can put the chart in the Detail section and remove the title. Then, for a form, you can create the title as a label in the Form Header section. For a report, you can add a label in the Report Header section and give it the same caption you would have given to the title of the chart.

1. The Sales Per State form should still be opened in Design View.
   Right-click an area of the chart -> Chart Object -> Open
2. Right-click the Sales Per State title and click Format Chart Title...
3. In the Format Chart Title dialog box, click the Font property page
4. In the Font combo box, select Times New Roman
5. In the Size combo box, select 22
6. Click the arrow of the Color combo box and select Blue
    
   
7. Click OK
8. Close Microsoft Graph
9. Save the form
10. To preview the chart, switch the form to Form View
11. Switch it back to Design View