Excel - Stacked/Cluster Charts

To create a stacked/cluster chart, select the data. Create will assume that the last column of data will be the clustered range by default. This function will add data to and manipulate the original chart data. In order that your original data remains unaffected, you should copy your chart data to a blank area of the worksheet and use this to create the chart.

Select New Chart in the ribbon or side bar.

• In the Chart dialog, select Stacked/Cluster.
• Select the required custom chart theme from the dropdown (the chart will be formatted accordingly).
• Click OK.

The Custom Chart Wizard will open with the fields populated based on your selection.

• Edit any of the fields by clicking on the button at the end to collapse the dialog and selecting the correct data or for titles, typing the text in manually.
  
• Click OK.

The formatted chart will appear on the worksheet.

Save the workbook. Send to PowerPoint or Word using Quick Send.