Current location - Loan Platform Complete Network - Big data management - WPS do horizontal bar chart how to make two data columns overlap together
WPS do horizontal bar chart how to make two data columns overlap together

In the "Toolbar" click "Insert" - "Chart" - "Bar Chart" - "Stacked Bar" - "OK"

. "Bar Chart" - "Stacked Bar" - "OK"

Click on the chart area in the toolbar in the upper right corner of the toolbar, click "Switch rows and columns"

Click on the "Total" area of the bar chart, right click - "Fill" - "No fill color"?

Or select "Properties" on the right side of the form - "Series Options" - "Fill and Line" - "Fill" - "No Fill"

Click on the chart, right click - "Chart Elements "-"Quick Layout"-"Layout 5"

The table data is now displayed below the bars

Click to hide the "Total" column. right-click on the "Total" bar area, right-click - "Chart Elements" - "Data Label"

< p>The values of the totals are now displayed

Click on the "Vertical" axis, and on the right side, under "Axis Options" - "Axis"

"Maximum" - "Maximum", "Maximum", "Maximum", "Maximum", "Maximum", "Maximum", "Maximum", "Maximum". - "Maximum" in Set to "20"

The entire table to beautify, adjust the font size, color, form lines and so on.