Create a chart in Microsoft Access 2013 or later

There is an (incorrect) rumor that charts are not supported anymore in MS Access, and that you have to export your data to Excel! Here is how you can create a chart using a graph type of your choice in Access without the help of any other application.

Go to “Create” > “Blank Report” and switch to “Design View”. From the top menu click the “Design” option. From the icons right below, select and click the “Chart” icon.

Click in the Design area of your report and drag your mouse to define the width and height of your chart. A dialogue opens to let you select the fields you need to include in your chart.

After you select also the type of chart you’d like to create, arrange your fields according to the type of your chart. After that you can create also a legend.

Note that Access may display the fields of your chart using long descriptions, such as “Sum of International Sales”. If you don’t want that, you need to change the field names of your chart’s datasheet by double (or right) clicking on your chart in design view.

This is not enough however; you need also to change these descriptions in the “Property Sheet” > “Data” of your chart (entering first the desing view of your chart). For example in the query

SELECT (Format([Date],"DDDDD")),Sum([Files]) AS [SumOfFiles],Sum([Images]) AS [SumOfImages]

just remove the “SumOf” part.

Enjoy!

contact the Editor of TheFreeWindows
don't miss   : :   Sleeper   Favorite Launcher   Savy   Gadgetarian
Gadgibility   Power Copy   Windows Rule   SearchALL Gadget   Amazon Gadget