In the Select Data Source window, click the Add button. Or, click the Chart Filters button on the right of the graph, and then click the Select Data… link at the bottom. Add a second data series from another sheetĬlick on the chart you've just created to activate the Chart Tools tabs on the Excel ribbon, go to the Design tab ( Chart Design in Excel 365), and click the Select Data button.
In this example, we will be creating the Stack Column chart:Ģ.
Open your first Excel worksheet, select the data you want to plot in the chart, go to the Insert tab > Charts group, and choose the chart type you want to make.
