How to convert a graph to a straight line using Log scales in excel?
0
$begingroup$
How to convert a graph to a straight line using Log scales in excel?
Is there a way to convert a graph plot to a straight line graph, using logarithmic scales on both axes.
Graph Example
functions logarithms graphing-functions
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
asked Dec 11 '18 at 11:34
DanDan
1
$endgroup$
|
show 1 more comment
0
$begingroup$
How to convert a graph to a straight line using Log scales in excel?
Is there a way to convert a graph plot to a straight line graph, using logarithmic scales on both axes.
Graph Example
functions logarithms graphing-functions
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
asked Dec 11 '18 at 11:34
DanDan
1
$endgroup$
$begingroup$
It's a little unclear what you want exactly. You can try changing one or both of the axes to logarithmic in order to make the graph look like a line. But surely, you don't want to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:39
$begingroup$
So is your question about how to use Excel (how to change the axes) or how to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:40
$begingroup$
@Matti P. Thanks for the prompt response, I do not want to change the data.
$endgroup$
– Dan
Dec 11 '18 at 11:42
$begingroup$
So just go to the axis range settings and change the range to logarithmic. Maybe it will result in a more "linear" graph, maybe not. But this is, I think, everything you can do at this stage. What's the difficulty you are facing?
$endgroup$
– Matti P.
Dec 11 '18 at 11:48
$begingroup$
@Matti P . Can you can make the graph perfectly linear? I would like to do this to verify the relationship on the photo above.
$endgroup$
– Dan
Dec 11 '18 at 11:49
|
show 1 more comment
0
0
0
$begingroup$
How to convert a graph to a straight line using Log scales in excel?
Is there a way to convert a graph plot to a straight line graph, using logarithmic scales on both axes.
Graph Example
functions logarithms graphing-functions
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
asked Dec 11 '18 at 11:34
DanDan
1
$endgroup$
How to convert a graph to a straight line using Log scales in excel?
Is there a way to convert a graph plot to a straight line graph, using logarithmic scales on both axes.
Graph Example
functions logarithms graphing-functions
functions logarithms graphing-functions
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
asked Dec 11 '18 at 11:34
DanDan
1
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
asked Dec 11 '18 at 11:34
DanDan
1
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
edited Dec 11 '18 at 16:26
Morgan Rodgers
9,70921439
9,70921439
asked Dec 11 '18 at 11:34
DanDan
1
asked Dec 11 '18 at 11:34
DanDan
1
asked Dec 11 '18 at 11:34
DanDan
1
1
$begingroup$
It's a little unclear what you want exactly. You can try changing one or both of the axes to logarithmic in order to make the graph look like a line. But surely, you don't want to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:39
$begingroup$
So is your question about how to use Excel (how to change the axes) or how to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:40
$begingroup$
@Matti P. Thanks for the prompt response, I do not want to change the data.
$endgroup$
– Dan
Dec 11 '18 at 11:42
$begingroup$
So just go to the axis range settings and change the range to logarithmic. Maybe it will result in a more "linear" graph, maybe not. But this is, I think, everything you can do at this stage. What's the difficulty you are facing?
$endgroup$
– Matti P.
Dec 11 '18 at 11:48
$begingroup$
@Matti P . Can you can make the graph perfectly linear? I would like to do this to verify the relationship on the photo above.
$endgroup$
– Dan
Dec 11 '18 at 11:49
|
show 1 more comment
$begingroup$
It's a little unclear what you want exactly. You can try changing one or both of the axes to logarithmic in order to make the graph look like a line. But surely, you don't want to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:39
$begingroup$
So is your question about how to use Excel (how to change the axes) or how to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:40
$begingroup$
@Matti P. Thanks for the prompt response, I do not want to change the data.
$endgroup$
– Dan
Dec 11 '18 at 11:42
$begingroup$
So just go to the axis range settings and change the range to logarithmic. Maybe it will result in a more "linear" graph, maybe not. But this is, I think, everything you can do at this stage. What's the difficulty you are facing?
$endgroup$
– Matti P.
Dec 11 '18 at 11:48
$begingroup$
@Matti P . Can you can make the graph perfectly linear? I would like to do this to verify the relationship on the photo above.
$endgroup$
– Dan
Dec 11 '18 at 11:49
$begingroup$
It's a little unclear what you want exactly. You can try changing one or both of the axes to logarithmic in order to make the graph look like a line. But surely, you don't want to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:39
$begingroup$
It's a little unclear what you want exactly. You can try changing one or both of the axes to logarithmic in order to make the graph look like a line. But surely, you don't want to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:39
$begingroup$
So is your question about how to use Excel (how to change the axes) or how to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:40
$begingroup$
So is your question about how to use Excel (how to change the axes) or how to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:40
$begingroup$
@Matti P. Thanks for the prompt response, I do not want to change the data.
$endgroup$
– Dan
Dec 11 '18 at 11:42
$begingroup$
@Matti P. Thanks for the prompt response, I do not want to change the data.
$endgroup$
– Dan
Dec 11 '18 at 11:42
$begingroup$
So just go to the axis range settings and change the range to logarithmic. Maybe it will result in a more "linear" graph, maybe not. But this is, I think, everything you can do at this stage. What's the difficulty you are facing?
$endgroup$
– Matti P.
Dec 11 '18 at 11:48
$begingroup$
So just go to the axis range settings and change the range to logarithmic. Maybe it will result in a more "linear" graph, maybe not. But this is, I think, everything you can do at this stage. What's the difficulty you are facing?
$endgroup$
– Matti P.
Dec 11 '18 at 11:48
$begingroup$
@Matti P . Can you can make the graph perfectly linear? I would like to do this to verify the relationship on the photo above.
$endgroup$
– Dan
Dec 11 '18 at 11:49
$begingroup$
@Matti P . Can you can make the graph perfectly linear? I would like to do this to verify the relationship on the photo above.
$endgroup$
– Dan
Dec 11 '18 at 11:49
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3035204%2fhow-to-convert-a-graph-to-a-straight-line-using-log-scales-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Mathematics Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3035204%2fhow-to-convert-a-graph-to-a-straight-line-using-log-scales-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
$begingroup$
It's a little unclear what you want exactly. You can try changing one or both of the axes to logarithmic in order to make the graph look like a line. But surely, you don't want to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:39
$begingroup$
So is your question about how to use Excel (how to change the axes) or how to modify the data, or ... ?
$endgroup$
– Matti P.
Dec 11 '18 at 11:40
$begingroup$
@Matti P. Thanks for the prompt response, I do not want to change the data.
$endgroup$
– Dan
Dec 11 '18 at 11:42
$begingroup$
So just go to the axis range settings and change the range to logarithmic. Maybe it will result in a more "linear" graph, maybe not. But this is, I think, everything you can do at this stage. What's the difficulty you are facing?
$endgroup$
– Matti P.
Dec 11 '18 at 11:48
$begingroup$
@Matti P . Can you can make the graph perfectly linear? I would like to do this to verify the relationship on the photo above.
$endgroup$
– Dan
Dec 11 '18 at 11:49