Excel -3- Figures and graphs

Creating a graph or a figure in MS Excel isn’t very complicated… as long as you have an idea of how the result should look like. Do you want to create a histogram? a bar graph? a pie chart? a scatter plot? Will you have one or several datasets to show in this graph? Will you need a secondary Y-axis? error bars? labels?

Axis Labels
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

pie 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 in a population, election results, polls, data based on proportions and percentage. Let’s learn how […]

11. Make a pie chart

legend box
You may realize by quickly checking the pie chart that we just made previously that not all of the parties are represented in the legend. This is due to a default setting that MS Excel uses and which restricts the size/display of the legend box. To display all categories or […]

12. Resize the legend box