Excel Graphic
Today I built a complex graph in excel. Assignment goal: reference independent variables in the function, so that the graph could be easily changed. Here is my work. At first, I set x-min. and x-max. manually, but the problem was that they could not be easily changed. In order for x-min and x-max to change automatically, I had to use the formula: x-min+(x-max.-x-min.)*(No. of cell/Total cells) This formula referenced all the numbers between min and max that could fit into a set number of cells.