Overview of Charts
Introduction to Charts
Creating a Chart in Microsoft Access
The information used to create a chart can come from a table, a query, or a join. 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.
Practical Learning: Creating a Chart
Creating a Chart in Microsoft Excel
Microsoft Excel is probably the most used tool for data analysis. This is partly because it provides many options. Microsoft Excel makes it possible and mostly easy to get data from other applications and analyze it there.
Practical Learning: Creating a Chart in Microsoft Excel
The Characteristics of a Chart
A Chart and its Container
A chart must be created in a container such as a form or a report in Microsoft Access, or a worksheet in Microsoft Excel. This also implies that the chart can only fit inside the size allocated by its host. When creating a chart in Microsoft Access, instead of simply clicking the form or report, you can click and drag immediately to set the primary size of the chart before releasing the mouse. Otherwise, after creating the chart, you can enlarge or heighten it in either Microsoft Access or Microsoft Excel.
Practical Learning: Resizing a Chart
The Sections of a Chart
To present its information, a chart is made of various sections:
Most or every one of these aspects can be displayed, hidden, 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:
This would open a separate application:
In Microsoft Graph, you can click or right-click the desired part.
Editing the Values of a Chart
As mentioned already, to create a chart in Microsoft Access, you use values from a table or a query. 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.
A Chart's Legend
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:
If you don't want to use a legend, you can delete it:
In the above 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.
Practical Learning: Using a Chart's Legend
The Title of a Chart
Practical Learning: Formatting a Chart's Title
To represent its numbers, a chart draws some geometric figures, depending on the type of chart. These figures can be rectangles, pie slices, triangles, cones, etc. To paint these figures, by default, the chart engine uses some randomly selected colors from its own list. You can either change these colors or apply some preset drawings. You can also design and use any custom picture to paint the chart's shapes.
To format the geometric figures of a chart, right-click one of them and click Format Data Series.
By default, when you have just created a chart that uses one column for its values, Microsoft Graph applies the same formatting, such as the same color, to all of its figures. You can keep this or treat each figure separately. To separate the figures, after opening Microsoft Graph, right-click a shape and configure it individually.
If you create a chart that uses more than one column, a separate category with its own color would be automatically created. You can then format each category as you see fit.
Practical Learning: Formatting a Chart's Shapes
By default, when a chart is drawn, it is equipped with shapes and a separate legend. If you want, you can display the value of each part and possibly a name next to it. This is done through a label. On a large chart, a label can also be used in the absence of a legend. In fact, you can delete a legend and simply use a label.
To add the labels to a chart, right-click a box on the chart and click Format Data Series. Once in the Format Data Series dialog box, click the Data Labels tab:
In the Label Contains group box, click the desired check box(es) and click OK.
Practical Learning: Formatting Labels on a Chart
The Chart's Background
One more way you can enhance the appearance of a chart is to draw a background wall behind it. By default, the background of a chart is painted in white. You can use a different color to paint it, a design pattern or a picture to cover it. Before formatting the chart, open Microsoft Graph. To format its wall, right-click the chart and click Format Chart Area... This would open the Format Chart dialog box where you can make the necessary changes.
Practical Learning: Formatting a Chart's Walls