Step 4: You can also use the DESIGN option to make the chart more presentable.Ĭlick on the Format option and then choose the font that suits the chart.īy this step, a stacked column chart is already prepared, but by using this step, we can add life to the old spreadsheet charts and make them look different. Step 3: After selecting the data as mentioned above and selecting a stacked column chart. In Column chart options, you will see several options choose the stacked column stack option to create stacked column charts. Step 2: Then go to the toolbar tab, here you can see the “insert” option.Ĭlick on Insert and then click on column chart options as shown below. Step 1: Firstly, enter the data for which you want to create a stacked column chart and select the data. Now we want to know what type of product has contributed what percentage to the total sales we can use a stacked column chart.
