make a pie chart from table of percentage

[titiakila]

Hello,
I work on ACCESS 2016.
I have a table with percentage for each value and I want to make a pie chart diagram with the mean of each column and the names of the columns as titles. After that I want to display on the pie chart the mean for each category in that example it is wine.


Here's my table :


What should I put as the row source of my graph ?



Thank you in advance

[June7]

How can a percentage be 900? Why is there no data in other fields and records? Is field set as a Double size?

Setting the Percent property does not change how data is stored. I never set formatting properties in table.

To show overall average of all wines together, consider:

Start with a UNION query object:

SELECT [No] AS ID, sugar AS Data, "sugar" AS Cat, wine_name AS Wine FROM Table2
UNION SELECT [No], alcohol, "alcohol", wine_name FROM Table2
UNION SELECT [No], acidity, "acidity", wine_name FROM Table2;

Then graph RowSource:

SELECT Cat, Avg(Data) AS AvgD FROM Query1 GROUP BY Cat;

[titiakila]

Sorry I just created a test database but I don't know why I couldn't change the values of the percentage just with integer values.
Yes thank you it is perfect what you wrote it really helped me thank you a lot !
Do you know what I should do to add a condition where to display the mean value of only wine of category bordeaux or wine of category beaujolais in the case where there are several of each ?
Thank you !

[June7]

Bind form to table or query. Bind textbox to wine_name field. Graph RowSource:

SELECT Cat, Avg(Data) AS AvgD FROM Query1 WHERE Wine = [Text1] GROUP BY Cat;