Wrong Average and standard deviation values in chart group of 3.

Hello again, I have figured out some of my graphs problems and it seems to me
that the excel file graph im linking here now visualizes the average lines wrong/inverted from the value i seeks to show in the graphs.

The png picture shows my "desired results" of the avg lines.
In the attached excel file below the picture u can see my excel graph example which has the wrong avg lines.

Calculating the avg myself gives the lines in the png which seem to show the correct avg on the graph,
however in my excel file it seems that the avg lines are inverted somehow?
For example the red graphs avg line in the excel file goes downwards when it should be more upwards.
It displays the value wrong atleast or the visualization is very off and i can figure out how to fix it.

I want percentages for normalization in the actual graphs so I can not just use the actual values only.
I would appreaciate quick help with this one.

Yes hello, I understand that the raw average calculation of the percentages always gives 20% which gives me a useless average line to me.

The problem is that I would really like to have the average and stdav lines like shown in my example picture, however this method only works when not normalizing the data to percentages,

My problem is that I want to have the values in the actual graph columns as normalized percentages, but ALSO have the average+stdav lines visible like if the data was not percentages,
Is it possible to somehow combine the percentage graph with raw values average and stdav lines onto that graph correctly?
I hope someone understands what i mean and maybe there is a better method to doing this..

Yes thank you, now the graphs average lines and size differences looks much better and more correct even with percentages, im just wondering if the standard deviation lines in the file you sent are also correct now as their values are different from my calculations before?