Hi all,
I am new on this forum so I apologize in advance if this is posted incorrectly or if the question has already been posted before. (in that case, I was not able to find it).
I am making graphs in excel which I know have a limit. I measure light in lumen and this value cannot be below 0, since that would be completely dark (it often doesn't even come close to it). On the y-axis I have the luminance in percentages, so 100% would be 0 lumen. On the x-axis I have the percentage of how much the quality of the contrastvalue of a screen improves. I want to add a trend line with a formula, but it should have the limit set on 100% (right now I've added a logarithmic trend line). I am not sure how to google this problem (I probably need to reread some of my math study books). I have tried it for a couple of days now but no luck. I registered here to hope someone can help me out. I have attached an image to make my problem more clear.
Thanks in advance!
excel graph.PNG
Bookmarks