The purpose of this paper is to explore work-arounds for the charts that, on the face of it, Excel cannot do. The examples given are intended for use by students at two levels of complexity. At the first level, we have suggested spreadsheets that react immediately to user-supplied data, much as a graphing package might do. At the second level, we have supplied only a brief description of how to construct the spreadsheet and chart that will display data in the form required. At this level, the student's involvement is much greater, and hence, their understanding of the construction of these charts is enhanced.

ExcelChartsV2.1.xls (46 kB)
File 1