You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...

Most notably, each chart type uses data differently, so you need to add Y-axis entries differently, depending on the type you use. Scatter Charts Scatter charts use two columns of data for each point.