CALCULATE AREA OF SCATTER CHART IN EXCEL 2018 SERIES
Next, under the Choose the chart type and axis for your data series set the Chart Type to Line for the Receipts and Outlays data series, and to Stacked Area for the Minimum, Surplus and Deficit data series. In the Change Chart Type dialog box select Combo under the All Charts tab.ģ7. Right-click the chart and then, on the shortcut menu, click Change Chart Type.ģ6. Press the Ok button to close the Select Data Source dialog box.ģ5. Do the same for Series4 and Series5 by referring to cells J1 and K1 respectively. Click the Ok button to close the Edit Series dialog box.ģ4. In the Edit Series dialog box, refer to cell I1 in the Series name edit box. In the Select Data Source dialog box, select Series3 data series and click the Edit button under Legend Entries (Series).ģ3. Right-click the chart and then, on the shortcut menu, click Select Data.ģ2. Next, select the chart and press Ctrl + V to paste the data series.ģ1. Press Ctrl + C to copy the data to the clipboard. Next, under Number set the Type to custom m/yyyy. Next, under Tick Marks set the Major type and Minor type to Outside.Ģ9. In the Format Axis pane, with Axis Options selected, under Units, set the Major to 5.Ģ8. In the Change Chart Type dialog box select Combo under the All Charts tab. Right-click the Horizontal (Category) Axis and then, on the shortcut menu, click Format Axis.Ģ7. Click the Ok button twice in a row to close the Edit Series dialog box and the Select Data Source dialog boxes.Ģ6. In the Edit Series dialog box, refer to cell G1 in the Series name edit box. In the Select Data Source dialog box, select Series2 data series and click the Edit button under Legend Entries (Series).Ģ5. Press the Ok button to close the Axis Labels dialog box.Ģ4. Next, in the Axis Labels dialog box, edit the Axis label range to include cells A13:A476. In the Select Data Source dialog box, click on the Edit button under Horizontal (Category) Axis Labels.Ģ3. Click the Ok button to close the Edit Series dialog box.Ģ2. In the Edit Series dialog box, refer to cell F1 in the Series name edit box. In the Select Data Source dialog box, select Series1 data series and click the Edit button under Legend Entries (Series).Ģ1. Right-click the chart and then, on the shortcut menu, click Select Data.Ģ0.