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: 358

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

Related posts about microsoft-excel

Related posts about charts