Charts are very useful for many Microsoft users, for example, they make information more understandable to your audience through visualization. Diagrams are often used in business for marketing or are used in schools to explain a point of view. Microsoft Access is a program that is used to manage a database, but you can create a chart in an Access report or form. In this tutorial, we will explain how to create a pie chart in report design in Microsoft Access.

How to create a pie chart in Access

Follow these steps to create a pie chart in Microsoft Access Report Design:

1. launch Microsoft Access.
2. Enter your details or use existing details.
3. Click Create and press report design.
4. Click Insert Modern Chart and select Pie Chart.
5. Paint Pie Chart on the grid.
6. In Data Source, select where the data comes from tables, queries, or both.
7. In Format Data Series, you can display data labels by checking the checkbox.
8. Open the property sheet by double-clicking the chart, then name the chart title and change the font color “Change Title” or remove the chart title.
9. Then click view in the Views group and select report view.
10. Right-click the report and select Save.
11. Name the report and click OK.
12. Now we have a report.

launch Microsoft Access .

Enter data or use existing data.

Click Create and press Report Design in Group report .

It will open on Report Design panel.

Click Insert Modern Chart in Group Controls .

Choose Pie Chart .

You will now see a mini plus sign with a chart. Draw it on the grid.

Chart settings panel will appear on the right.

In the Data Source you will see the options: Tables, Queries and Both. These parameters indicate where you want to receive data from. In this tutorial, we choose Tables because the data we want to turn into a pie chart is in a table.

Following are the Axis (Category), Legend (Series), and Values ​​(Y-Axis). We don’t want any more changes to the diagram, so we leave these sections alone.

Now click Format.

In Format Data Series, you can display data labels by clicking Display Data Labels. You will now see the data labels on the chart.

If you want to add a chart title name to a pie chart, double click the chart and Property Sheet will open.

In the panel, scroll down until you see a chart title on the opposite side and enter a chart title.

If you want to change the chart title color. On the property page, scroll down until you see Chart Title Font Color; click the dropdown arrow to select a color, or the 3 dots at the end.

If you want to hide the chart title, click the 3 dots and select a white background color in the Chart Title Font Color box.

Close property panel and Chart Settings panel.

Then click view in the Views group and select report view to see how the pie chart will look in the report.

To save a report, right-click the report and select Save.

Save As will open. Name the report and click OK.

We now have a chart in the report.

Can you create charts in Access?

Yes, you can create charts in Microsoft Access such as Excel, PowerPoint, Outlook and Word. When it comes to Word, Excel, Outlook, and PowerPoint, you can find charts in Insert , but when it comes to Access, you must create a chart in Form or Report Design.

How to create a chart in Access 2007?

Follow these steps to create a chart in Access 2007:

1. When creating, create an empty form.
2. In the blank form layout, click design view.
3. You will now see a graph icon in the Controls group.
4. Draw a square on the empty shape grid.
5. The Chart Wizard opens.
6. Choose Next.
7. Add the fields you want to combine and the numeric data you want to add to the chart.
8. Click Next.
9. Now you see a wide selection of charts from which you can choose.
10. Select a chart, then click next.
11. Give your chart a title, then click Finish.

How to insert a modern chart in Access?

To insert a modern chart in Access, open Form Design or Report Design panel and insert Modern Chart in the Management group; you will see various charts in the menu, select a chart and draw it in the Form Design or Report Design grid.

We hope this guide will help you understand how to create a pie chart in Microsoft Access.
The above shows how to create a pie chart in Access. If you have any questions regarding the above steps, please give useguide.net find out in the comments section. useguide.net will contact you for a solution as soon as possible.