Engineers-Excel.com

     
Engineering using Spreadsheets

Multifunction Plotter

Description
Fourier Series
Loan Payments

This tool will allow the user to plot upto 5 functions on the same graph. It is an extension of the Function Analysis tool.

Download

.xls file (230 KB) or .zip (30 KB)

How to use

Key in the functions to be plotter in the cells B4 to B10. The function must be keyed in with the equal to sign, as in the  Function Analysis tool. Key in the range of the plot in the cells B12 and B13.

For example, the plot the functions y=x and y=sin(x) between -2 and 2, key in '=x' in cell B4 and '=sin(x)' in cell B5. Key in -2 and 2 in the cells B12 and B13 respectively. If done correctly, the screen will look like this.

How it works

This tool uses Data Tables to plot the value of the functions at a 1000 points over the specified range. These are then plotted on the graph. For more details, see How the Function Analysis Tool works.