Access

Formatting Charts

A chart created using the New Form dialog box is positioned on a form. As such, the form acts as its parent. The chart can only fit inside of the form. Based on this, you can enlarge a form to make available more space for the chart. After enlarging and/or heightening a form, you can increase the side of the chart to have a bigger picture and better appreciate a chart.

1. In the Database window, click Forms and double-click the chtFlavorFrequency form to open it.

2. After viewing the chart, switch the form to Design View

3. Right-click the chart, position the mouse on Chart Object and click Edit. This opens the Microsoft Graph window.

4. Using the lower-right corner of the the Microsoft Graph window, resize it as much as you can afford.

5. Using the lower-right corner of the form, increase the size of the chtFlavorFrequency window as much as possible.

6. After enlarging the chtFlavorFrequency window, click somewhere close to the circle until a surrounding square appears .

7. Click that square and drag left to move the chart to the left.

8. In the same way, click the box that displays the title above the chart and drag it left to place it above the chart.

9. Also, click the box that displays East West North and drag it left to place it close to the chart.

10. After resizing, close the Microsoft Graph window.

11. Back in Microsoft Access, resize the box that surrounds the chart until the chart and the words around it are visible. You may need to continue various trial-and-error attempts until you come to the following.

12. Save and close the form.