Google Sheets - Stacked column chart

This tutorial teaches you how to make stacked column chart. If you have multiple series of data, stacked column chart can be used. Suppose a company make two types of products, and the products are sold all around the world. The data is below. 1. Select the data. Click Insert > Chart . A stacked column chart is shown automatically. 2. We want to add data labels as well title to the vertical axis. Right click the chart, click Series > Apply to all series . 3. Check Data labels 4. Now you see the data labels. They make the chart more readable. 5. To add vertical axis, right click the chart, click Chart & axis titles > Vertical axis title . 6. Fill in the vertical axis title "Number of items sold". Now you get a pretty stacked column chart.