How to generate a round-numbers graph in Excel?
Posted
by
tcheregati
on Super User
See other posts from Super User
or by tcheregati
Published on 2012-07-03T12:06:39Z
Indexed on
2012/07/11
3:18 UTC
Read the original article
Hit count: 393
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!
© Super User or respective owner