The Charts that Excel Cannot Do
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 gr...
Main Author: | |
---|---|
Format: | Article |
Language: | English |
Published: |
McMaster University
|
Series: | Spreadsheets in Education |
Online Access: | http://sie.scholasticahq.com/article/4526-the-charts-that-excel-cannot-do.pdf |
_version_ | 1797971016830418944 |
---|---|
author | John Baker |
author_facet | John Baker |
author_sort | John Baker |
collection | DOAJ |
description | 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. |
first_indexed | 2024-04-11T03:26:04Z |
format | Article |
id | doaj.art-a4bbba3b8f1140a5909e9a2c15acbbff |
institution | Directory Open Access Journal |
issn | 1448-6156 |
language | English |
last_indexed | 2024-04-11T03:26:04Z |
publisher | McMaster University |
record_format | Article |
series | Spreadsheets in Education |
spelling | doaj.art-a4bbba3b8f1140a5909e9a2c15acbbff2023-01-02T07:38:10ZengMcMaster UniversitySpreadsheets in Education1448-6156The Charts that Excel Cannot DoJohn BakerThe 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.http://sie.scholasticahq.com/article/4526-the-charts-that-excel-cannot-do.pdf |
spellingShingle | John Baker The Charts that Excel Cannot Do Spreadsheets in Education |
title | The Charts that Excel Cannot Do |
title_full | The Charts that Excel Cannot Do |
title_fullStr | The Charts that Excel Cannot Do |
title_full_unstemmed | The Charts that Excel Cannot Do |
title_short | The Charts that Excel Cannot Do |
title_sort | charts that excel cannot do |
url | http://sie.scholasticahq.com/article/4526-the-charts-that-excel-cannot-do.pdf |
work_keys_str_mv | AT johnbaker thechartsthatexcelcannotdo AT johnbaker chartsthatexcelcannotdo |