Figures and tables in a laboratory report have a particular standard of presentation, much higher than that of the figures you would put in laboratory notebook.
You may use any software you desire for producing graphs. Discovery Skills students will usually use Excel or other spreadsheet software, but at later levels the use of Python or other specialist data presentation software is encouraged.
Key Points
Graphs
Some key points worth noting regarding graphs:
Your graph should have…
Your graph should not have…
Below are two examples of graphs that have been produced using Excel - the first is a bad example, the second a good one -with commentary on their features.
Fig 1. A good graph, annotated
Fig 2. A bad graph, annotated.
Like figures, tables must have a caption and must be numbered. Tables are not figures (i.e. not called Fig. 1, Fig. 2, etc.) and instead should be called Table 1, Table 2, etc.. Removing unnecessary horizontal or vertical lines will improve the presentation of your tables. All the entries, including the headings, should fit comfortably in the width or height of the columns or rows; long headings should thus be avoided. Below you can see a few other things to take note of when using tables.
Don’t include tables of data when the information is adequately given in a graph or by a few words of text; this is redundant and wasteful of space. Below is the same data presented in two formats; if presenting your data in a graphical form enhances the ability to convey information (as is the case here) you do not need to include the table of data, just the graph.
Note that the Florence Nightingale Graphical Prize for Graphical Excellence is awarded at each level to exceptional presentation of data to illustrate physical phenomena.