Graph equations in excel are easy to plot and this tutorial will walk all levels of excel users through the process of showing line equation and adding it to a graph. They can only plot data values that you assign. Plotting the original y-data and the calculated result ycalc on the same graph tells us that the parameters of the function are not yet correct.
Actually there is a formula that can help you to keep the formula cell empty until data entered in reference cells.
Graphing lines on an excel spreadsheet. Excel charts arent that smart though. Open the worksheet that contains the chart. You can create your owns of course.