The realization method of Excel chart classification and segmented color display

The realization method of Excel chart classification and segmented color display

Different categories, different years are displayed in different colors, if you can achieve it is too handsome. This article describes the Excel chart classification, segmentation color display implementation methods.

According to the source table, inserted column chart, always feel a little awkward.

Business section after merging, the chart is a lot more refreshing.

Again, the source data, the column on the Chart Division division show different colors.

In the same way, Blue makes a graph that shows different colors in a year.

Supplemental: Adding auxiliary columns is also a common idea for charts.

WPS Tutorial

Word Tutorial

Excel Tutorials