How to create a multi-column stacked column chart from data in an Excel table

php Xiaobian Strawberry teaches you how to use data in Excel tables to make a multi-column stacked column chart. Through this form of chart display, the relationship between multiple sets of data can be compared more intuitively, helping users analyze the data more clearly. Next, we will introduce detailed steps so that you can easily master the skills of making stacked column charts.

1. As shown in the figure, convert the original table data into the form as shown in the figure. There are gaps between data and there are gradients just like the columns of the chart.

2. Chart production

1. Select the deformed data area - click Insert - Recommended chart.

2. Click on All Charts - Stacked Column Chart.

3. Data column - set the data series format - category spacing (adjusted to 0). The effect is shown in the figure.

3. Beautification of charts

1. Add titles and data sources - add titles according to the needs of the table. The titles should be as concise as possible and can reflect the content of the table and highlight the The point you want to make. Font (serif font: line thickness is different, suitable for small fonts, but the clarity is not high when projected, sans-serif font: the same thickness, more suitable for large fonts, beautiful when projected)

中文Font: Microsoft YaHei, boldface.

2. Add a background setting - mainly monochrome.

The above is the detailed content of How to create a multi-column stacked column chart from data in an Excel table. For more information, please follow other related articles on the PHP Chinese website!