Excel: Stacked columns - how to create the chart

If you want to manage large amounts of data, the Excel spreadsheet program is a good choice. Here you have various functions at your disposal to analyze and illustrate the data. For example, you can use a chart with stacked columns.

Stacked columns: how to use the chart in Excel

In Excel, you have numerous functions and formulas at your disposal to edit and analyze the data in your tables. If you want to visualize them, then it is possible to display them in a chart. For this purpose, you can use the stacked column chart, for example. With this, partial values of different criteria are summarized according to columns stacked on top of each other. This can be useful for sales or cost comparisons. However, it is important that your table has the correct structure.

1. The first two columns should be filled for the x-axis label. The first two rows correspond to the y-axis of the chart.
2. Also make sure that there are blank rows between the data blocks, so that there is also a space between the groups in the chart. This makes it look clearer.
3. Once you have adjusted the format accordingly, select all the information you want to include in the chart. Then go to "Menu" > "Insert" > "Chart".
4. Now select "Stacked Columns" as the type.
5. When you right-click on the data series in the chart, select "Format Data Series". Under "Options", select the spacing width 0.