Table and chart from spreadsheet data

The data in the table below have been extracted from a spreadsheet. The data file was saved in csv format and uploaded to the server.

This script extracted the data and produced the table and bar chart. To update the page, it is only necessary to upload a new csv file - the script does the rest.

Note that the bars can be given any colour and, being divs, could accept a background image if required. The bars shown here are value-sensitive - see the key at the bottom of the page. The numbers are as in the data file, but could have been converted to percentages. Scaling is automatic to fit the width and the height of the chart area. The full-width Y-axis bars are optional.

Hover the mouse over each bar for a note about that month.

(These notes would be part of the csv file)

X axis legend

Example bar colour scheme

green: more than 15;       red: less than 5;       orange: between 5 and 10