Arrow left
Back to product guides
Google Sheets Tips

How to Make a Stacked Column Chart in Google Sheets

In this article, you will learn how to create a line chart in Google Sheets. A line chart is helpful when you want to show continuous data over time, such as monthly revenue growth rate.

How to create a Stacked Column Chart in Googe Sheets

  1. Select a data set you want to visualize.
  2. Go to the “Insert” tab and click ”Chart”, or navigate to the “Insert chart” icon in the toolbar.
  3. Then, you have a default chart on a sheet, and a chart editor shows up on the right.
  4. In the “Setup” tab of the editor, select “Stacked column chart” in the “Chart” type section.
  5. Double-check the data range selected and adjust it if needed.
  6. Also, ensure the correct ranges are input in X-axis and Series sections.
  7. Move to the “Customize” tab in the chart editor and customize your chart if you want.
How to insert a chart and change the “Chart type” and other key elements in the Chart editor

Learn how to customize the design of the chart. Assume you want to create the graph in the picture below by changing its detailed design and formatting. You need to go through the steps under the screenshot.

How to change the details of the default chart
  1. In the “Chart style” section, go to “Font” and select “Arial”.
  2. Navigate to “Chart & axis titles”. Choose “Chart title” in the drop-down list at the top and enter a chart title in the text box. Click the “Bold” icon in “Title format” and select blue in “Title text color”. Ensure the font is “Arial”.
  3. In the “Series” tab, choose ”Division D“ at a pull-down menu (not “Apply to all series”), change “Line color” to red and its occupancy to “100%”, and select “4px” for “Line thickness”.
  4. Stay in the “Series” section. Change the choice at the top tab to “Apply to all series”, navigate to the bottom of the section, check the box next to “Data labels” to a data label for each category, and the one next to “Total data label” to show total amounts of the bars. Double-check labels’ font is “Arial”.
  5. Navigate to the “Legend” section. Add a legend by selecting “Bottom” in “Position” and make it bold.
  6. Determine the y-axis by inputting minimum and maximum values for the range in text boxes.
Step 1: Change the font of a stacked column chart.

Step 2: Type in a chart title and change its font and color

Step 3: Change the formatting of a segment in the chart

Step 4: Add a data label to each segment and the total data label

Step 5: Add legend and adjust its style

Step 6: Define the y-axis range by inputting the minimum and maximum values

As you can find many options and choices in each section (e.g., the “Vertical axis” section shown right above), there are many ways to customize your graph. Check and try other details we haven’t touched upon in this example to better understand and optimize your chart for your output purpose.

How can you change the order of legend and data?

As a default setting, the order of segments in a column chart is reversed to the order of the items in the data source. You can change the order of categories in the chart by following the steps below. We recommend that you do this before changing the detailed designs of your chart.

  1. Go to the “Set up” tab in the chart editor.
  2. Move on to the “Series” section and change the order of the series as you want. For example, suppose you're going to make “Division A” the top category in a bar (or the leftmost segment in the legend), followed by Division B, C, and D from the top or the left. In that case, you can reverse the order of series names - the order should be “Division D”, “Division C”, “Division B”, and “Division A” from the top.
  3. The legend and the order of segments in bars are automatically updated.

How do you make other types of graphs?

It is easy. After inserting a graph, select another chart pattern in the “Chart” type section. You can learn how to create other basic charts in the following articles.

How to Make a Column Chart in Google Sheets

How to Create a Pie Chart in Google Sheets

How to Make a Waterfall Chart in Google Sheets

How to Make a Line Chart in Google Sheets

How to Make a Bubble Chart in Google Sheets

Are you interested in creating a customized KPI dashboard reflecting your data in real-time? Check LiveFlow and the following template with graphs.

Here is an example of how charts are utilized for data sharing and reporting.

Analyze your live financial data in a snap

Are you learning this tip to build a financial model or financial KPI dashboard or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711