Stacked columns in Excel charts
This tip applies to Excel Online, which is included in the free Office 365 package for students and pupils. The differences to other versions of Excel , however, are not serious, since the Overlay for the most part, identical.
- First of all, you need to create a data table. In our example, we have the cost of two trips added to these in the diagram represent.
- It is important that you use categories and individual components, which can be represented as parts of the pillars.
- Now highlight the data table, and add to it with "Insert/chart", a chart. You can select the type "column" and then by "Stacked columns" to specify.
- The chart can now be either normal or as a percentage. Select the suitable version.
- If the label is wrong, you can swap over the "row/column switch" the data. In order for these to be shown correctly again.
Stacked column chart in Excel
If you Excel for your finances to use, you will have with this extension your financial planning in the blink of an eye in the handle.
