Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

graphs

ResolvedVersion 2003

Valerie has attended:
Access Intermediate course

Graphs

How can you create graphs from Access?

RE: Graphs in Access

Dear Valerie

Thank you for attending Access Intermediate course !! I hope you enjoyed the course and benefited from it.

Creating Charts is quite straightforward in Access compared to Excel.

To create charts you have to be in Forms.

Click on the New Button

Choose Chart Wizard from the list and then choose the Table or Query which contains the data for chart

Press OK

Choose (Double-click) the fields that need to be displayed in the chart

Press Next

Choose the type of chart suitable for the fields you selected.

Press Next

Drag and drop the fields to the relevant places in the chart

Press Next

Type a suitable name for the Chart form

Press Finish

In the Form if the Chart seems to be too small then go to the design view and adjust the size to your requirement.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Fri 26 Dec 2008: Automatically marked as resolved.

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.