Present your data in a scatter chart or a line chart - Microsoft Support Create a scatter chart · Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data you want to plot in a scatter chart ...