How to plot data in Excel with axes using logarithmic scaling?
See the axis of this chart
As I marked the axis with red oval, the axis is flocused toward the main bounds. How can I plot such a chart?
microsoft-excel charts
edited Jan 31 at 7:43
fixer1234
19.1k144982
asked Jan 30 at 18:26
RohRoh
1084
add a comment |
See the axis of this chart
As I marked the axis with red oval, the axis is flocused toward the main bounds. How can I plot such a chart?
microsoft-excel charts
edited Jan 31 at 7:43
fixer1234
19.1k144982
asked Jan 30 at 18:26
RohRoh
1084
I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.
– fixer1234
Jan 30 at 22:41
@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.
– Roh
Jan 31 at 6:04
That's just plotting on a log scale.
– fixer1234
Jan 31 at 6:33
@fixer1234 Could you please post your answer with an example?
– Roh
Jan 31 at 7:01
add a comment |
See the axis of this chart
As I marked the axis with red oval, the axis is flocused toward the main bounds. How can I plot such a chart?
microsoft-excel charts
edited Jan 31 at 7:43
fixer1234
19.1k144982
asked Jan 30 at 18:26
RohRoh
1084
See the axis of this chart
As I marked the axis with red oval, the axis is flocused toward the main bounds. How can I plot such a chart?
microsoft-excel charts
microsoft-excel charts
edited Jan 31 at 7:43
fixer1234
19.1k144982
asked Jan 30 at 18:26
RohRoh
1084
edited Jan 31 at 7:43
fixer1234
19.1k144982
asked Jan 30 at 18:26
RohRoh
1084
edited Jan 31 at 7:43
fixer1234
19.1k144982
edited Jan 31 at 7:43
fixer1234
19.1k144982
edited Jan 31 at 7:43
fixer1234
19.1k144982
19.1k144982
asked Jan 30 at 18:26
RohRoh
1084
asked Jan 30 at 18:26
RohRoh
1084
asked Jan 30 at 18:26
RohRoh
1084
1084
I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.
– fixer1234
Jan 30 at 22:41
@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.
– Roh
Jan 31 at 6:04
That's just plotting on a log scale.
– fixer1234
Jan 31 at 6:33
@fixer1234 Could you please post your answer with an example?
– Roh
Jan 31 at 7:01
add a comment |
I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.
– fixer1234
Jan 30 at 22:41
@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.
– Roh
Jan 31 at 6:04
That's just plotting on a log scale.
– fixer1234
Jan 31 at 6:33
@fixer1234 Could you please post your answer with an example?
– Roh
Jan 31 at 7:01
I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.
– fixer1234
Jan 30 at 22:41
I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.
– fixer1234
Jan 30 at 22:41
@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.
– Roh
Jan 31 at 6:04
@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.
– Roh
Jan 31 at 6:04
That's just plotting on a log scale.
– fixer1234
Jan 31 at 6:33
That's just plotting on a log scale.
– fixer1234
Jan 31 at 6:33
@fixer1234 Could you please post your answer with an example?
– Roh
Jan 31 at 7:01
@fixer1234 Could you please post your answer with an example?
– Roh
Jan 31 at 7:01
add a comment |
1 Answer
1
active
oldest
votes
Based on your comments, the specific thing you're looking for is plotting with a log scale. I made a simple example with some data that would be close to a straight line on a log scale, and didn't bother matching the other formatting in your example:
The two axes are similar. My settings for the X axis are shown. I also turned on minor grid lines on both axes. The Excel I had handy was v2007, so the dialog window might look a little different from yours.
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
add a comment |
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2fsuperuser.com%2fquestions%2f1400206%2fhow-to-plot-data-in-excel-with-axes-using-logarithmic-scaling%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Based on your comments, the specific thing you're looking for is plotting with a log scale. I made a simple example with some data that would be close to a straight line on a log scale, and didn't bother matching the other formatting in your example:
The two axes are similar. My settings for the X axis are shown. I also turned on minor grid lines on both axes. The Excel I had handy was v2007, so the dialog window might look a little different from yours.
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
add a comment |
Based on your comments, the specific thing you're looking for is plotting with a log scale. I made a simple example with some data that would be close to a straight line on a log scale, and didn't bother matching the other formatting in your example:
The two axes are similar. My settings for the X axis are shown. I also turned on minor grid lines on both axes. The Excel I had handy was v2007, so the dialog window might look a little different from yours.
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
add a comment |
Based on your comments, the specific thing you're looking for is plotting with a log scale. I made a simple example with some data that would be close to a straight line on a log scale, and didn't bother matching the other formatting in your example:
The two axes are similar. My settings for the X axis are shown. I also turned on minor grid lines on both axes. The Excel I had handy was v2007, so the dialog window might look a little different from yours.
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
Based on your comments, the specific thing you're looking for is plotting with a log scale. I made a simple example with some data that would be close to a straight line on a log scale, and didn't bother matching the other formatting in your example:
The two axes are similar. My settings for the X axis are shown. I also turned on minor grid lines on both axes. The Excel I had handy was v2007, so the dialog window might look a little different from yours.
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
answered Jan 31 at 7:22
fixer1234fixer1234
19.1k144982
19.1k144982
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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.
To learn more, see our tips on writing great answers.
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%2fsuperuser.com%2fquestions%2f1400206%2fhow-to-plot-data-in-excel-with-axes-using-logarithmic-scaling%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
I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.
– fixer1234
Jan 30 at 22:41
@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.
– Roh
Jan 31 at 6:04
That's just plotting on a log scale.
– fixer1234
Jan 31 at 6:33
@fixer1234 Could you please post your answer with an example?
– Roh
Jan 31 at 7:01