...
From the Toolbox, select Workbooks, then select a workbook and worksheet.
Select the Design Workspace icon if needed.
Right-click an element in a chart, such as a bar in a graph, and choose Display Arrangement.
Choose one of the following options:
Automatic: The system will decide to show the chart as stacked or not.
Stacked: The chart will be stacked.
Regular: The chart will not be stacked. For Bar and Column chart, the columns will be clustered.
Overlap: This option will only be available for Bar and Column charts. The chart will not be stacked. The columns will not be clustered and will overlap with each other.
Anchor overlap overlap
NOTE: The overlapping columns feature is available for Bar and Column charts. If the 'Overlap' option is selected and you change the view type to a chart that is neither Bar nor Column, the option will automatically switch to 'Automatic.'
100% Stacked: The chart will be 100 % stacked.
...