Excel how to scatter plot from tables

-2

I have an Excel 2016 worksheet with three tables:

Table with X coordinates (multiple rows and multiple columns)

Table with Y coordinates (same number of rows and columns than X)

Table with labels (same number of rows and columns than X)

Screenshot

I need to make a scatter plot, and the tables are too large to manually add each series to the chart.
Each position on the X table has the value Y and label on the same position in the tables Y and Label.

I need to plot a single serie, with all the X, Y and label data.

My plan is to turn the tables into three columns (a column each for X, Y, and label), using some Index function, and use the chart feature in the classic way.

But is there a simpler/more practical solution?

edited Feb 21 at 12:13

asked Feb 8 at 13:45

cohoridit

2

We need more information to be able to respond. If it is simply three single columns for X, Y, and labels, you don't need to do anything special. If series are represented somehow, we need to know how (row ranges? separate columns in each table?). Please add a screenshot or mock-up of the tables with enough description so we can understand what you need to do, and any inherent complications (like the ranges not being in the same sequence in each table). If you're looking for actual formulas, we need to know the layout and size accurately. Also, describe the index function you envision.

– fixer1234
Feb 8 at 14:22

2

Thanks for adding the image, but it's just an illegible pattern of what looks like a lot of stuff. It doesn't provide any of the detail people need to understand your question.

– fixer1234
Feb 8 at 17:09

The purpose of the image is to show that the tables are large, and all of the same size. Their articular values are not relevant.

– cohoridit
Feb 21 at 12:14

add a comment |

-2

I have an Excel 2016 worksheet with three tables:

Table with X coordinates (multiple rows and multiple columns)

Table with Y coordinates (same number of rows and columns than X)

Table with labels (same number of rows and columns than X)

Screenshot

I need to plot a single serie, with all the X, Y and label data.

My plan is to turn the tables into three columns (a column each for X, Y, and label), using some Index function, and use the chart feature in the classic way.

But is there a simpler/more practical solution?

edited Feb 21 at 12:13

asked Feb 8 at 13:45

cohoridit

2

We need more information to be able to respond. If it is simply three single columns for X, Y, and labels, you don't need to do anything special. If series are represented somehow, we need to know how (row ranges? separate columns in each table?). Please add a screenshot or mock-up of the tables with enough description so we can understand what you need to do, and any inherent complications (like the ranges not being in the same sequence in each table). If you're looking for actual formulas, we need to know the layout and size accurately. Also, describe the index function you envision.

– fixer1234
Feb 8 at 14:22

2

Thanks for adding the image, but it's just an illegible pattern of what looks like a lot of stuff. It doesn't provide any of the detail people need to understand your question.

– fixer1234
Feb 8 at 17:09

The purpose of the image is to show that the tables are large, and all of the same size. Their articular values are not relevant.

– cohoridit
Feb 21 at 12:14

add a comment |

-2

I have an Excel 2016 worksheet with three tables:

Table with X coordinates (multiple rows and multiple columns)

Table with Y coordinates (same number of rows and columns than X)

Table with labels (same number of rows and columns than X)

Screenshot

I need to plot a single serie, with all the X, Y and label data.

My plan is to turn the tables into three columns (a column each for X, Y, and label), using some Index function, and use the chart feature in the classic way.

But is there a simpler/more practical solution?

edited Feb 21 at 12:13

asked Feb 8 at 13:45

cohoridit

I have an Excel 2016 worksheet with three tables:

Table with X coordinates (multiple rows and multiple columns)

Table with Y coordinates (same number of rows and columns than X)

Table with labels (same number of rows and columns than X)

Screenshot

I need to plot a single serie, with all the X, Y and label data.

My plan is to turn the tables into three columns (a column each for X, Y, and label), using some Index function, and use the chart feature in the classic way.

But is there a simpler/more practical solution?

microsoft-excel charts microsoft-excel-2016

edited Feb 21 at 12:13

asked Feb 8 at 13:45

cohoridit

edited Feb 21 at 12:13

asked Feb 8 at 13:45

cohoridit

edited Feb 21 at 12:13

asked Feb 8 at 13:45

cohoridit

asked Feb 8 at 13:45

cohoridit

asked Feb 8 at 13:45

cohoridit

2

We need more information to be able to respond. If it is simply three single columns for X, Y, and labels, you don't need to do anything special. If series are represented somehow, we need to know how (row ranges? separate columns in each table?). Please add a screenshot or mock-up of the tables with enough description so we can understand what you need to do, and any inherent complications (like the ranges not being in the same sequence in each table). If you're looking for actual formulas, we need to know the layout and size accurately. Also, describe the index function you envision.

– fixer1234
Feb 8 at 14:22

2

Thanks for adding the image, but it's just an illegible pattern of what looks like a lot of stuff. It doesn't provide any of the detail people need to understand your question.

– fixer1234
Feb 8 at 17:09

The purpose of the image is to show that the tables are large, and all of the same size. Their articular values are not relevant.

– cohoridit
Feb 21 at 12:14

add a comment |

2

We need more information to be able to respond. If it is simply three single columns for X, Y, and labels, you don't need to do anything special. If series are represented somehow, we need to know how (row ranges? separate columns in each table?). Please add a screenshot or mock-up of the tables with enough description so we can understand what you need to do, and any inherent complications (like the ranges not being in the same sequence in each table). If you're looking for actual formulas, we need to know the layout and size accurately. Also, describe the index function you envision.

– fixer1234
Feb 8 at 14:22

2

Thanks for adding the image, but it's just an illegible pattern of what looks like a lot of stuff. It doesn't provide any of the detail people need to understand your question.

– fixer1234
Feb 8 at 17:09

The purpose of the image is to show that the tables are large, and all of the same size. Their articular values are not relevant.

– cohoridit
Feb 21 at 12:14

We need more information to be able to respond. If it is simply three single columns for X, Y, and labels, you don't need to do anything special. If series are represented somehow, we need to know how (row ranges? separate columns in each table?). Please add a screenshot or mock-up of the tables with enough description so we can understand what you need to do, and any inherent complications (like the ranges not being in the same sequence in each table). If you're looking for actual formulas, we need to know the layout and size accurately. Also, describe the index function you envision.

– fixer1234
Feb 8 at 14:22

Thanks for adding the image, but it's just an illegible pattern of what looks like a lot of stuff. It doesn't provide any of the detail people need to understand your question.

– fixer1234
Feb 8 at 17:09

The purpose of the image is to show that the tables are large, and all of the same size. Their articular values are not relevant.

– cohoridit
Feb 21 at 12:14

add a comment |

1 Answer
1

active

oldest

votes

Select the Y values, and insert the chart. It will use your Y values and dummy X values (1, 2, 3, etc.).

Right click the chart, and choose Select Data.

Select the series in the list, and choose Edit. The box for 'Series X Values' is blank. Click in the box and select the X values. It doesn't matter if they are not right next to the Y values.

Finally, click the '+' icon next to the chart and check Data Labels. You'll get default labels that display the Y values.

Select the data labels and press Ctrl+1 to open the Format Data Labels task pane. Under Label Options, click the bar chart icon, then click on Label Options. Under Label Contains, check the box for Value From Cells, and select the range that contains these values. Then uncheck the other Label Contains boxes.

answered Feb 14 at 4:28

Jon Peltier

2,9321420

There are too many series to manually edit each one, and I don't need many series. Only one.

– cohoridit
Feb 21 at 12:12

So is it too many series, or just one?

– Jon Peltier
Feb 22 at 19:01

add a comment |

Your Answer

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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1403542%2fexcel-how-to-scatter-plot-from-tables%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Select the Y values, and insert the chart. It will use your Y values and dummy X values (1, 2, 3, etc.).

Right click the chart, and choose Select Data.

Select the series in the list, and choose Edit. The box for 'Series X Values' is blank. Click in the box and select the X values. It doesn't matter if they are not right next to the Y values.

Finally, click the '+' icon next to the chart and check Data Labels. You'll get default labels that display the Y values.

answered Feb 14 at 4:28

Jon Peltier

2,9321420

There are too many series to manually edit each one, and I don't need many series. Only one.

– cohoridit
Feb 21 at 12:12

So is it too many series, or just one?

– Jon Peltier
Feb 22 at 19:01

add a comment |

Select the Y values, and insert the chart. It will use your Y values and dummy X values (1, 2, 3, etc.).

Right click the chart, and choose Select Data.

Select the series in the list, and choose Edit. The box for 'Series X Values' is blank. Click in the box and select the X values. It doesn't matter if they are not right next to the Y values.

Finally, click the '+' icon next to the chart and check Data Labels. You'll get default labels that display the Y values.

answered Feb 14 at 4:28

Jon Peltier

2,9321420

There are too many series to manually edit each one, and I don't need many series. Only one.

– cohoridit
Feb 21 at 12:12

So is it too many series, or just one?

– Jon Peltier
Feb 22 at 19:01

add a comment |

Select the Y values, and insert the chart. It will use your Y values and dummy X values (1, 2, 3, etc.).

Right click the chart, and choose Select Data.

Select the series in the list, and choose Edit. The box for 'Series X Values' is blank. Click in the box and select the X values. It doesn't matter if they are not right next to the Y values.

Finally, click the '+' icon next to the chart and check Data Labels. You'll get default labels that display the Y values.

answered Feb 14 at 4:28

Jon Peltier

2,9321420

Select the Y values, and insert the chart. It will use your Y values and dummy X values (1, 2, 3, etc.).

Right click the chart, and choose Select Data.

Select the series in the list, and choose Edit. The box for 'Series X Values' is blank. Click in the box and select the X values. It doesn't matter if they are not right next to the Y values.

Finally, click the '+' icon next to the chart and check Data Labels. You'll get default labels that display the Y values.

answered Feb 14 at 4:28

Jon Peltier

2,9321420

answered Feb 14 at 4:28

Jon Peltier

2,9321420

answered Feb 14 at 4:28

Jon Peltier

2,9321420

answered Feb 14 at 4:28

Jon Peltier

2,9321420

There are too many series to manually edit each one, and I don't need many series. Only one.

– cohoridit
Feb 21 at 12:12

So is it too many series, or just one?

– Jon Peltier
Feb 22 at 19:01

add a comment |

There are too many series to manually edit each one, and I don't need many series. Only one.

– cohoridit
Feb 21 at 12:12

So is it too many series, or just one?

– Jon Peltier
Feb 22 at 19:01

There are too many series to manually edit each one, and I don't need many series. Only one.

– cohoridit
Feb 21 at 12:12

So is it too many series, or just one?

– Jon Peltier
Feb 22 at 19:01

add a comment |

draft saved

draft discarded

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.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Bdtyktl