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

Popular posts from this blog