I’m not an Excell Expert

So if anyone can help me with my problem i would be very thankfull.

I have an excell worksheet with lots of data for each day of the week. I have manage to get the average of the data for each day of the week using a formula.

Now i want to make a chart with the weekdays and the average.

The problem is that when generating the chart, it don’t display the right average values, seems like it’s not seeing de average value but the formula i used.
This chart must be dynamicly, when there’s a change in the data, it also changes in the average as well as the chart.

Microsoft Excel 2003/2007