Monday, July 28, 2014

How To Inserting a Graph Chart in Access 2003

You can create a chart from data in a table or query using the Chart Wizard. The wizard steps you through the process to select the data and chart type. The Graph chart uses two views to display the information that makes up a graph: the datasheet, which is a spreadsheet-like grid of rows and columns that contains your data, and the chart, which is the graphical representation of the data. A datasheet contains cells to hold your data. A cell is the intersection of a row and column. Graph Chart comes with a gallery that lets you change the chart type and then format the chart to get the result that you want. You can also save your customized settings as a format to use when you create other charts.

Create a Graph Chart

graphics/1_icon.jpg
In Design view, click the Insert menu, and then click Chart.
graphics/2_icon.jpg
Drag the pointer to create a rectangle the size of the chart you want to create.
graphics/3_icon.jpg
When the Chart Wizard appears, click the Both option, and then click the table or query you want to use to make the chart. Click Next to continue.
graphics/4_icon.jpg
Click a field, and then click the Add button for each field you want to chart. Click Next to continue.
graphics/5_icon.jpg
Click the chart type you want, and then click Next.
graphics/6_icon.jpg
Make any layout modifications that are desired, and then click Next.
graphics/7_icon.jpg
If you want the chart to change from record to record, select the fields that link the document and the chart, and then click Next.
graphics/8_icon.jpg
Enter a chart name, click the No option if you do not want to display the legend, and then click Finish.
graphics/09inf25.jpg

Change a Chart Type

graphics/1_icon.jpg
In Design view, double-click the chart on your form or report.
graphics/2_icon.jpg
Click the Chart Type button list arrow.
graphics/3_icon.jpg
Click the button for the chart type you want.
graphics/09inf26.jpg

Save Chart Settings as a Custom Chart Type

graphics/1_icon.jpg
In Design view, double-click the chart to select it.
graphics/2_icon.jpg
Click the Chart menu, and then click Chart Type.
graphics/3_icon.jpg
Click the Custom Types tab.
graphics/4_icon.jpg
Click the User-defined option.
graphics/5_icon.jpg
Click Add.
graphics/6_icon.jpg
Type a name and description for the chart, and then click OK.
graphics/7_icon.jpg
Click OK.
graphics/09inf27.jpg