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