Display 2 survey results in one chart

murrr62 

Step 1: create a chart based on the data on one of the sheets. It does not matter which one you choose.

Step 2: click in the newly selected chart and if necessary activate the 'Chart Design' tab of the ribbon.

Step 3: In the Data group of this tab, click Select Data.

Step 4: Under 'Legend entries (series)', click Add.

Step 5: Click in the 'Series name box'. Enter a name for the new series, or select a cell that contains the name.

Step 6a: Only if your chart is an XY Scatter chart: click on the 'Series X values' box. Activate the other sheet and select the x-values range on that sheet. Click in the 'Series Y' values box. Clear its contents and select the y-values range.

Step 6b: For all other chart types: click in the 'Series values' box. Clear its contents, then activate the other sheet and select the y-values range.

Step 7: Click OK to close the Edit Series dialog

Step 8: Click OK to close the Select Data dialog.