Common chart types

Under the Insert tab you will find the chart tools. You can choose to create column or line charts (with or without markers). You can also choose between a standard chart (each series separately), a stacked chart (series stacked on top of each other) or a 100% stacked chart (series stacked on top of each other, as parts of 100%).

If you imagine, as an example, that you want to show oil production per country over time, then:

• A standard chart shows, for each year, each country’s oil production as columns in different colours side by side.
• A stacked chart shows, for each year, each country’s production as different colours in a single column
• A 100% stacked chart shows, for each year, each country’s production as different colours in a single column, and the columns for every year will always be equally tall. It is thus the distribution between the different countries that is emphasised, not the total.