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.

Comments
Post a Comment