If you want to plot an XY point in Excel, you need to highlight the datasets. After that, track down the following steps: Quick Analysis (Ctrl+Q) > Charts > More Charts > All Charts > X Y (Scatter) > Scatter options.