Jump to content
Sign in to follow this  

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.

Thanks in advance!

Share this post


Link to post
Share on other sites

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

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 this post


Link to post
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 this post


Link to post
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! :D

Share this post


Link to post
Share on other sites

Join the conversation

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

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...