Today I quickly tried out a few different techniques with Excel to visualise my 2021 running data (up to and including 25th March) – mostly conditional formatting of charts and their data labels to try and show as much information as possible in single charts of different types.
The first chart did not turn out very well. It is pictured below. It shows the distance I ran each time using red formatting for all runs at an average of over 11 km/h. There is not space for the labels (which show the average speed for each run), and this could certainly not be used for a whole year of data.
The next chart came out better. It shows the average speed of each run using red for runs of over 10km. Each data point is labelled with the distance of the run. There is also a threshold line at 11 km/h to clearly show which runs exceeded this average speed.
The next chart shows the WMA age grading (a comparative measure of the quality of runs of different lengths) for all runs of between 10km and 12km. The columns show the grading which is a percentage, and different colours are used for the runs depending on whether they were better than the 53% or 50% thresholds. Each column is labelled with the distance of the corresponding run.
The final chart below again shows the WMA grading for all the runs, the distance of each run is used as the label for each data point, and there is a trend line to show a 5 run rolling average of the relative quality of the runs.
