# How on earth can I log an exponential graph on excel?

## Recommended Posts

Hello guys,

I am currently doing my physics IAs and i am stuck at processing the graphs. I have performed the experiments and have generated several graphs, which are all exponential. Now, how can I turn that exponential line into a straight line on excel? I know I have to log it, but i am not sure how to do it. I've tried changing the scale of the graph to logarithmic scale and converting the data one by one with =ln(), but both methods failed to give me a proper straight-line-with-proper-axes-and-proper-linear-trendline graph.

Anyone has experience in this? Can you tell me how to do it on excel, if not, on other applications?

I really need your help, my IA final draft is due in 3 weeks.

##### Share on other sites

sorry, do you want to plot a linear graph or an exponential graph?

what you do is tabulate the data on excel, select it and create a graph, choose scatter graph. then you'll see the data points. look for menu Format, select Trendline. add a trendline. right click on the line on the graph, choose Format Trendline and choose Exponential. tick show equation and R^2 value if you like.

##### Share on other sites

i already have the exponential graph. Now i want to calculate the gradient of that graph, which i can only find if i log it (making the graph a straight line). Do you know how to do that?

##### Share on other sites

oh. don't plot x against y then. try plotting e^x against y? you should perhaps get a linear graph.

##### Share on other sites

ohh...i found a way, it seems that i have to log both axes first, it works the second time... hehehe

but it was great recommendation from you desy to do e^x...thanks!

##### Share on other sites

You have to log both sides, and then you can find the intercepts and the gradient.

##### Share on other sites

yes, i finally found a way to do that...

now, do you have any idea what to do when after logging both sides, the graph is not linear?

##### Share on other sites

graphing e^x against y instead of graphing x against y haha

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.