Stacked Bar chart in Access

Recently a colleague asked how to display a stacked bar chart in Access.

Create a table where one column is used to group data e.g. Year, and additional fields containing values to be stacked e.g Revenue. For example, the columns Revenue by Item Group will be stacked by Year.

Next, create a new form and add a diagram object to the form

In the diagram wizard select your table with data. Next move the Year and the Revenue fields from the table to the diagram data box.

Next choose a bar chart. There is no stacked bar chart in the wizard.

Drag and drop the year to the axis drop box. Drag and drop the Revenue fields to the data box on the left. By double click on field in the left box you can choose the aggregation function e.g. Count, Sum, None

Preview the diagram, it should look like this

Finish the wizard. A diagram is placed on the form.

Double click the diagram will open the designer view. Here right click on the diagram an open change the diagram type to stacked bar chart

Format the diagram as you like. Save your design and open the form