Journal cover Journal topic
Journal of Micropalaeontology An open-access journal of The Micropalaeontological Society
Journal topic

Journal metrics

Journal metrics

  • IF value: 1.179 IF 1.179
  • IF 5-year value: 1.107 IF 5-year
    1.107
  • CiteScore value: 2.6 CiteScore
    2.6
  • SNIP value: 0.601 SNIP 0.601
  • IPP value: 1.23 IPP 1.23
  • SJR value: 0.491 SJR 0.491
  • Scimago H <br class='hide-on-tablet hide-on-mobile'>index value: 27 Scimago H
    index 27
  • h5-index value: 10 h5-index 10
Volume 17, issue 2
J. Micropalaeontol., 17, 104–104, 1998
https://doi.org/10.1144/jm.17.2.104
© Author(s) 1998. This work is distributed under
the Creative Commons Attribution 4.0 License.
J. Micropalaeontol., 17, 104–104, 1998
https://doi.org/10.1144/jm.17.2.104
© Author(s) 1998. This work is distributed under
the Creative Commons Attribution 4.0 License.

  01 Dec 1998

01 Dec 1998

Using spreadsheets to produce stacked histogram, stacked line and spindle charts

Jeremy R. Young and Markus Geisen Jeremy R. Young and Markus Geisen
  • Palaeontology Department, The Natural History Museum, Cromwell Road, London SW7 5BD, UK

Abstract. INTRODUCTION

By far the most widely available computer programs for recording, manipulating, and displaying numerical data are spreadsheets, such as Microsoft Excel™ and Lotus 1-2-3™. These are powerful and flexible tools and for most workers this is an obvious way of recording micropalaeontological data. However, they have been primarily produced for business users and have limited abilities when it comes to plotting scientific graphs. This note describes some indirect but rapid methods, for using the standard graphing tools in such packages, to produce additional types of graphs of value to micropalaeontologists.

STACKED HISTOGRAM CHARTS

Figure 1 is a stacked histogram chart, produced in Microsoft Excel™. This type of diagram is useful, for instance, in displaying variations in size of a species between samples through a section. Stacked histogram charts are not directly supported by any spreadsheets that I have seen. As a result, they can usually only be produced by rather inefficient techniques. For example, making a separate chart for each sample and then combining them in a graphics program. The indirect approach used here is to separate each true data series with a mirror image padding data series, which is not displayed. The entire diagram is then plotted as a single chart. The steps for doing this are:

(1) Enter the data (specimens per size class) in a spreadsheet (samples v. size classes).

(2) Between each pair of data columns insert a column with equations which will calculate mirror image padding data. These will have the form C3 = . . .

Publications Copernicus
Download
Citation