How to adjust domain shape of a MS Excel surface plot
up vote
-1
down vote
favorite
I've collected some data that I'd like to display as a surface plot. The data was gathered by sampling in a mesh domain, with one axis having coarse spacing and the other axis having fine spacing. I'd like to plot this as a surface with a square domain, but excel likes to display it as a very skinny rectangle. I'm sure it's a simple problem but I can't find any formatting option that allows me to set the physical characteristics of the domain mesh.
EDIT: After going through every axis option I could find and consulting these 1 2 3 office support documents, I'm going to conclude this basic functionality is not possible.
EDIT: Some figures to illustrate the problem.
Some randomly generated data to be plotted by any of the 3d graph options. The goal would be to rescale the graphic into a cube.
Below are some options for the value axis (vertical/z-axis). It doesn't allow you to control window height but at least there's some scale options.
[
5
And here are the options for the series axis (depth/y-axis). Note the lack of options.
microsoft-excel
asked Nov 19 at 20:17
roro
991
add a comment |
up vote
-1
down vote
favorite
I've collected some data that I'd like to display as a surface plot. The data was gathered by sampling in a mesh domain, with one axis having coarse spacing and the other axis having fine spacing. I'd like to plot this as a surface with a square domain, but excel likes to display it as a very skinny rectangle. I'm sure it's a simple problem but I can't find any formatting option that allows me to set the physical characteristics of the domain mesh.
EDIT: After going through every axis option I could find and consulting these 1 2 3 office support documents, I'm going to conclude this basic functionality is not possible.
EDIT: Some figures to illustrate the problem.
Some randomly generated data to be plotted by any of the 3d graph options. The goal would be to rescale the graphic into a cube.
Below are some options for the value axis (vertical/z-axis). It doesn't allow you to control window height but at least there's some scale options.
[5
And here are the options for the series axis (depth/y-axis). Note the lack of options.
microsoft-excel
asked Nov 19 at 20:17
roro
991
If you can provide a sample, it will be better to help you.
– Lee
Nov 20 at 1:08
Hi @Lee, graphics added.
– roro
Nov 20 at 16:36
not sure if my understanding is correct, you can select the Chart- go to Design- Select Data- Edit the Horizontal Axis Labels manually: ibb.co/huZdeq
– Lee
Nov 21 at 1:08
Hi Lee, this option just changes the labels, I'm looking to change the aspect ratio of the graph.
– roro
Nov 26 at 22:00
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I've collected some data that I'd like to display as a surface plot. The data was gathered by sampling in a mesh domain, with one axis having coarse spacing and the other axis having fine spacing. I'd like to plot this as a surface with a square domain, but excel likes to display it as a very skinny rectangle. I'm sure it's a simple problem but I can't find any formatting option that allows me to set the physical characteristics of the domain mesh.
EDIT: After going through every axis option I could find and consulting these 1 2 3 office support documents, I'm going to conclude this basic functionality is not possible.
EDIT: Some figures to illustrate the problem.
Some randomly generated data to be plotted by any of the 3d graph options. The goal would be to rescale the graphic into a cube.
Below are some options for the value axis (vertical/z-axis). It doesn't allow you to control window height but at least there's some scale options.
[5
And here are the options for the series axis (depth/y-axis). Note the lack of options.
microsoft-excel
asked Nov 19 at 20:17
roro
991
I've collected some data that I'd like to display as a surface plot. The data was gathered by sampling in a mesh domain, with one axis having coarse spacing and the other axis having fine spacing. I'd like to plot this as a surface with a square domain, but excel likes to display it as a very skinny rectangle. I'm sure it's a simple problem but I can't find any formatting option that allows me to set the physical characteristics of the domain mesh.
EDIT: After going through every axis option I could find and consulting these 1 2 3 office support documents, I'm going to conclude this basic functionality is not possible.
EDIT: Some figures to illustrate the problem.
Some randomly generated data to be plotted by any of the 3d graph options. The goal would be to rescale the graphic into a cube.
Below are some options for the value axis (vertical/z-axis). It doesn't allow you to control window height but at least there's some scale options.
[5
And here are the options for the series axis (depth/y-axis). Note the lack of options.
microsoft-excel
microsoft-excel
asked Nov 19 at 20:17
roro
991
asked Nov 19 at 20:17
roro
991
edited Nov 20 at 16:35
asked Nov 19 at 20:17
roro
991
asked Nov 19 at 20:17
roro
991
asked Nov 19 at 20:17
roro
991
991
If you can provide a sample, it will be better to help you.
– Lee
Nov 20 at 1:08
Hi @Lee, graphics added.
– roro
Nov 20 at 16:36
not sure if my understanding is correct, you can select the Chart- go to Design- Select Data- Edit the Horizontal Axis Labels manually: ibb.co/huZdeq
– Lee
Nov 21 at 1:08
Hi Lee, this option just changes the labels, I'm looking to change the aspect ratio of the graph.
– roro
Nov 26 at 22:00
add a comment |
If you can provide a sample, it will be better to help you.
– Lee
Nov 20 at 1:08
Hi @Lee, graphics added.
– roro
Nov 20 at 16:36
not sure if my understanding is correct, you can select the Chart- go to Design- Select Data- Edit the Horizontal Axis Labels manually: ibb.co/huZdeq
– Lee
Nov 21 at 1:08
Hi Lee, this option just changes the labels, I'm looking to change the aspect ratio of the graph.
– roro
Nov 26 at 22:00
If you can provide a sample, it will be better to help you.
– Lee
Nov 20 at 1:08
If you can provide a sample, it will be better to help you.
– Lee
Nov 20 at 1:08
Hi @Lee, graphics added.
– roro
Nov 20 at 16:36
Hi @Lee, graphics added.
– roro
Nov 20 at 16:36
not sure if my understanding is correct, you can select the Chart- go to Design- Select Data- Edit the Horizontal Axis Labels manually: ibb.co/huZdeq
– Lee
Nov 21 at 1:08
not sure if my understanding is correct, you can select the Chart- go to Design- Select Data- Edit the Horizontal Axis Labels manually: ibb.co/huZdeq
– Lee
Nov 21 at 1:08
Hi Lee, this option just changes the labels, I'm looking to change the aspect ratio of the graph.
– roro
Nov 26 at 22:00
Hi Lee, this option just changes the labels, I'm looking to change the aspect ratio of the graph.
– roro
Nov 26 at 22:00
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1376785%2fhow-to-adjust-domain-shape-of-a-ms-excel-surface-plot%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
If you can provide a sample, it will be better to help you.
– Lee
Nov 20 at 1:08
Hi @Lee, graphics added.
– roro
Nov 20 at 16:36
not sure if my understanding is correct, you can select the Chart- go to Design- Select Data- Edit the Horizontal Axis Labels manually: ibb.co/huZdeq
– Lee
Nov 21 at 1:08
Hi Lee, this option just changes the labels, I'm looking to change the aspect ratio of the graph.
– roro
Nov 26 at 22:00