How do I create a simple percentage bar chart

[charlie010019]

Clearly being dumb but need to create this sort of chart (which I mocked up in Excel):





...in Access from this table (greatly simplified for illustration):



Just to go on a form or report. Can easily do if I put "protein", "carbs" and "fats" as values in new table (e.g. in a "FoodGroups" field) but that is tedious given how the data is structured. Surely there's a simple way?

Cheers!

[ranman256]

make a query that produces the results, bind this query to the chart.

for setup do this:
in the chart, dbl-click the chart object,
in the chart datasheet, delete the fake data,
paste the results of your query. This will 'prime the pump' with actual data.
save

now the chart should show query results.

[charlie010019]

make a query that produces the results, bind this query to the chart.

for setup do this:
in the chart, dbl-click the chart object,
in the chart datasheet, delete the fake data,
paste the results of your query. This will 'prime the pump' with actual data.
save

now the chart should show query results.

That worked perfectly! Thank you!