- 1). Enter your data into Excel. Use column A for your X-Axis and columns B and C for your two y-axis data sets.
- 2). Highlight the data that you want to chart.
- 3). Click "Insert" in the Excel Ribbon, then click "Chart."
- 4). Select "XY (Scatter)."
- 5). Select "Press and Hold to View Sample" to see a sample of your chart.
- 6). Click "Next." There are three more options menus in the chart wizard. Select whichever options you want from each menu and click "Next." When you get to the final menu, click "Finish" and your chart will appear on the worksheet.
SHARE
