Office 2010 - Access

Lesson 63: “Charts” (2)

63/76 Lessons 


To modify a “Chart” in a form or report, double-click it in “Form view” or “Design view”. This brings you into the ” Microsoft Chart” view. You can see the two toolbars that replace the “Ribbon” and the navigation window has gone to the left of the window. By default, the data sheet is shown above the “Chart” but, you can move it by clicking and dragging the title bar.


When we change data in the datasheet, they are immediately updated in the “Chart”.
To hide the datasheet, click the “Datasheet View” button. The “Datasheet View” button is a toggle button, in other words, clicking this again will make the datasheet visible again.

When the whole “Chart” is selected, we have a number of formatting options.


For example we have the “by row” and “by column” buttons to show us the data by row or by column. In other words, the columns become rows and the rows become columns .

You have the toggle button “table” and this adds a “Data table” below the “Chart”.
You have the “Chart Type” button which when clicked, opens a drop-down menu where you can choose another type of “Chart”.
You have buttons to add “Grid lines”, both as the “Category axis Gridlines” and the “Value axis Gridlines”.
We have the “Legend” toggle button, that we can use to show or hide a legend. We also have a button to show or hide the drawing toolbar.
And finally we have the “Fill Color”, to change the setting of the background color of the “Chart”.

When we click the downward pointing arrow next to the “Chart Objects” box, the list of all objects from our “Chart” are shown.
To show an object, you have to first select it. You can do this in the “Chart” itself, but my experience teaches me that it’s easier to do this in “Chart Objects” box.
Clicking the formatting button, opens a dialog format. This dialog changes for each object that is selected. So, you can set the font color of your title, which is not possible in the standard toolbar.



You've completed Lesson 63