So, you want to know how to create a scatter plot in Excel. ... Because the scatter chart only plots numbers, the points and lines will be based on the columns of numbers you chose to plot.

You would notice that the line graph and scatter plot chart curves are different. However, these charts are static. You could also consider creating Dynamic charts in Excel .

To create a funnel plot in Excel, you need to follow the aforementioned guide. That said, you can enter the data first, choose the cells, and go to Insert > Waterfall . Here you can find an option ...