added charting functionality and fixed openspreadsheet method