How to generate a round-numbers graph in Excel?
- by tcheregati
folks!
Now, I have an Excel file with measurements I made of some color patches (I work at a Press company), with a device called spectrophotometer.
Here it is:
https://docs.google.com/open?id=0B0i8fdSf2ihzRlFYNWd4anItenM
Density and Hue are two characteristics of each color patch.
The thing is: I'm looking at a non-linear increase between the 25 Color Density measurements I took, but I NEED to know exactly how the color's Hue changes as the color's Density increases.
For that, I needed Excel to give me round numbers for the X axis (for example 0,70 to 1,50 in 0,05 increments).
And for that, obviously, I needed Excel to calculate the probable Hue Values corresponding to those ghost/round/not-given values of Density (like a kind of advanced rule of three).
So, can anyone help me on that?
Thanks a lot!