Let us plot the mathematical function sin(x) versus x. When you are plotting data from an experiment, the points (the x's and y's) are generated in the lab and are simply typed or pasted into Excel. When you are plotting a mathematical function, you need to generate the points in Excel.
First we must generate the x values. To do this, we must choose the domain (the first and last points) we want to plot as well as the spacing between consecutive points. Let us choose here to plot sin(x) versus x for x between 0 and 10 with a spacing Dx=0.1.