Forum Discussion
Excel - plotting values of average-function
Hello, As I recently begun to do some statistics regarding the active COVID19 cases in my own country, I was busy smoothing out the daily numbers by using the "Average"-function over a period of sev...
Dearhansleroy
I hereby send you a prepared sheet with two graphs. Yellow is what is being plotted, and blue(manual values) is what should be plotted! It's like the average-graph is averaging itself. Hopefully there will be no problems with dates ;)!
Greetings
Ok, I have finally solved my issue, it's so stupid, the average-function returns double values, as it usually does. Just they are displayed as integers in the cells and as function in the upper field. Normally double values are getting displayed directly and have to be in- or decreased manually.
I solved my issue by adding a round-function to the average-function-> e.g. =ROUND(AVERAGE(C72:C78);0), and the graph was displayed correctly!
Thanks to those having tried solving it!