Is it possible to create a range of values evenly distributed in rows of column from single value? For example: from the value of 35, I need to create range from 0 to 35 evenly distributed on 900 rows (single column). I have data from 3 color channels acquired from section line on microphotograph. I have 900 values for each channel and I need to distribute it on 35 micrometer line for the graph. Is there a function in excel for this kind of operation? Other way than manual laborious icrement (35 divided by 900) adding from 0 to 35 into 900 rows. It will be very helpful.
Alternatively, is it possible to just make the X axis on graph somehow show 0-35 range?