Create a Chart with TwoLevel Axis Label You need to change the original data firstly, and then create column chart based on your data Just do the following steps Step1 select the first column (product column) except for header row Step2 go to DATA tab in the Excel Ribbon, and click Sort A to Z command under Sort &In Excel, we usually insert a chart for better displaying data, sometimes, the chart with more than one series selections In this case, you may want to show the series by checking the checkboxes Supposing there are two series in the chart, check checkbox1 to display series 1, check checkbox2 to display series 2, and both checked, display twoSelect the series on the first chart;
How To Close The Gaps Between Chart Series In An Excel Stacked Clustered Column Chart Excel Dashboard Templates