Excel16 -3- Figures and graphs




Since it is your first chart, we’ll take it easy and use a single dataset. Let’s use the previous example, concentrating on temperatures in Bergen between Sept. 19th and Sept. 27th 2015. The “easy way” consists in selecting the data which has to be contained in the graph: this means […]

3. Make your first line chart












It is not so often that one gets to use a pie chart… and it is not so often that such a chart is used for the right purpose. Pie charts can be used to represent different categories of a population, polls, data referring on proportions and percentage. Let’s learn how to make […]

11. Make a pie chart


You may realize, looking at the pie chart that we just made previously, that the design of the chart area is rather inadequate. The chart itself is ridiculously small compared to the legend. This is essentially due to a default setting that MS Excel uses and which restricts the size/position of the […]

12. Resize the legend box





A boxplot (box plot, or whisker plot) is a compact, but efficient way to represent a dataset using descriptive stats. This “little diagram” combines informative, standard values such as the first and third quartiles (the bottom and top of the box, respectively), the median (the flat line inside the box) […]

15. How to draw a histogram



A boxplot (box plot, or whisker plot) is a compact, but efficient way to represent a dataset using descriptive stats. This “little diagram” combines informative, standard values such as the first and third quartiles (the bottom and top of the box, respectively), the median (the flat line inside the box) […]

16. Create a boxplot