Hi everyone,

I am trying to create this special log-log plot. The y values can range anywhere from around 100 to almost 5,000, and the x values range between 0 and 1. For this type of analysis, I need both axes to be logarithmic and a linear trendline placed on the log-log plot. I also need the x intercept to be at x=1. From this plot, I hope to get the y intercept and the slope of the linear trendline.

I know these requirements seem random and arbitrary, but the data needs to be this graphed this way for what I'm trying to do.

I am wondering if there is a way to do this in Excel.

Any help would be greatly appreciated,