If you want to make use of some math formulas for practical applications or just to show off your Excel creativity, you can utilize kind of slide show: = refreshable charts based on your brilliant formula.
Follow these steps:
- Open a new workbook. Enter any two numbers into your worksheet (Sheet1), e.g. 1 in cell A2 and 2 in B2.
- Start with creating a simple XY scatter chart based on your entries. This chart is named as "Chart 1".
- Delete the two numbers you've just entered. You don't need them.
- Expand the width of column A to e.g. 200, move there the chart and resize it to the size of your choice.
- In cell D1, type the formula you want to chart, in the format using explicitly normal math signs and functions, e.g. x^2+5*sqrt(x)-3 .
- Enter the low and high limits (of your choice) for the Left value and the Right value of x axis, then also the Low and High limits for the number of Points you want to be plotted, as shown in the example below (cells D3:E5).
- In cells F3:F5, enter RANDBETWEEN formulas as shown in the example, cells F3:F5.