Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the jonradio-private-site domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /hum/web/sitestest.hum.uu.nl/htdocs/wp-includes/functions.php on line 6114
Skills Earth Sciences | Creating graphs (Excel)

Skills Earth Sciences

Creating graphs (Excel)

You can use excel to plot data in simple graphs. Often, students use Excel when they have to make a graph as it is a familiar interface and it is therefore easy to use. When you are already handling/structuring/saving your data in Excel, you can easily and quickly plot your data to explore it, and spot if you have made any big mistakes.

Using Excel to make scientific graph has some disadvantages however: the graph options in Excel are limited to the default functions, and there is no option to add packages for specific, more advanced graph types. If you want to make more advanced graphs, it might be better to use a different program. Additionally, layout options are limited. The standard layout is well-known and might look unprofessional. Therefore, we recommend that you not use the default style. Instead, develop your own style with an appropriate colour scheme.

A license for MS Office 365 is available for free through UU with a Solis-id.

Resources:

  • The Excel module offers video tutorials for making graphs in Excel, specifically scatter plots and histograms in Excel.
  • For a step-by-step guide for creating graphs in Excel, see this website.