A stacked column chart is used to show how individual data series contribute to the total value within each category. For example, if you want to visualize your company's monthly sales data to understand how different product categories contribute to your total monthly revenue, you can use a stacked column chart to identify which product categories are the primary drivers of revenue and which contribute less to the total sales.

Google Sheets’ Chart Editor allows you to create a stacked column chart and modify certain elements of it, such as the title, axis labels, legend, and colors.

Step 1: Open the Google Sheets document

Log in to your Google account, then open the Google Sheet that contains the data you want to use in your stacked column chart.

Step 2: Select the data range

Click and drag to select the data range for the stacked column chart, after choosing the sheet you want to work on.

Step 3: Click on the Insert > Chart in the menu at the top of the screen

Once you have your data selected, navigate to the "Insert" menu located at the top of the Google Sheets interface. From there, click on "Chart" in the dropdown menu to open the Chart Editor sidebar on the right side.

Step 4: In the Chart Editor panel, select Chart type > Stacked Column chart

In the Chart Editor, select "stacked column chart" from the list of available chart types.

Step 5: Move the line chart to its own sheet (optional)

If you want to work on your chart without any distractions, you can easily move it to a separate sheet. Simply click on the three vertical dots located at the top right corner of the chart and select the "move to own sheet" option. Google Sheets will automatically create a new sheet named "Chart 1," where you can edit and view your chart.

Step 6: Customize the chart

You can access the Chart Editor by clicking on "Edit chart" to customize your chart.

Step 6.1: Change the chart’s title

When creating a chart, it is essential to add titles to label the X and Y axes and make the chart's purpose clear. To do so, click on the text boxes and add descriptive titles. You can also click on the "Chart & axis titles" option and type the chart's title in the given text box. You can choose the font, size, format, and text color for the chart title according to your preferences. Additionally, if you want, you can change the chart style as well.

Step 6.2: Change chart style (optional)

In the Chart Editor, navigate to "Chart Style" and click under "Background Color" to modify the chart's background. You can also modify the font using the dropdown under “Front.”

Step 7: Share it with your team

Once you’re done with the chart, use the “Share button” at the top right corner of the screen to share it with everyone on your team. Alternatively, you can publish the chart or download it as an image.