Microsoft Visio: define data position on master shape
I am very very beginner at Visio and I have been struggling days on something which is probably very basic.
I have a set of data defined in an excel file, this way:
Name,Age,City
Paul,23,Paris
Jacques,55,London
Thomas,67,New York
I am trying to create a master composed of 3 rectangles, one for the field "Name", one for "Age" and one for "City". Each rectangle is supposed to contain one of the field in the above file.
Then I would like to create shapes of this master populated with data when I import data from my excel file.
Preferably I would like to avoid using VBA.
Is this realistic with Visio? Can someone provide with a good method to realize this?
Edit
Maybe my question might be simplified as this one: is there a way to link the data of one SHAPE to another SHAPE?
In other words, I create a shape A and associate data (name, age) to it. Then I create a shape B, and I would like B's data to always be equal to A's data, e.g if I change A.name, B.name also changes.
I've tried many different manipulations without success.
microsoft-visio shapes master
add a comment |
I am very very beginner at Visio and I have been struggling days on something which is probably very basic.
I have a set of data defined in an excel file, this way:
Name,Age,City
Paul,23,Paris
Jacques,55,London
Thomas,67,New York
I am trying to create a master composed of 3 rectangles, one for the field "Name", one for "Age" and one for "City". Each rectangle is supposed to contain one of the field in the above file.
Then I would like to create shapes of this master populated with data when I import data from my excel file.
Preferably I would like to avoid using VBA.
Is this realistic with Visio? Can someone provide with a good method to realize this?
Edit
Maybe my question might be simplified as this one: is there a way to link the data of one SHAPE to another SHAPE?
In other words, I create a shape A and associate data (name, age) to it. Then I create a shape B, and I would like B's data to always be equal to A's data, e.g if I change A.name, B.name also changes.
I've tried many different manipulations without success.
microsoft-visio shapes master
add a comment |
I am very very beginner at Visio and I have been struggling days on something which is probably very basic.
I have a set of data defined in an excel file, this way:
Name,Age,City
Paul,23,Paris
Jacques,55,London
Thomas,67,New York
I am trying to create a master composed of 3 rectangles, one for the field "Name", one for "Age" and one for "City". Each rectangle is supposed to contain one of the field in the above file.
Then I would like to create shapes of this master populated with data when I import data from my excel file.
Preferably I would like to avoid using VBA.
Is this realistic with Visio? Can someone provide with a good method to realize this?
Edit
Maybe my question might be simplified as this one: is there a way to link the data of one SHAPE to another SHAPE?
In other words, I create a shape A and associate data (name, age) to it. Then I create a shape B, and I would like B's data to always be equal to A's data, e.g if I change A.name, B.name also changes.
I've tried many different manipulations without success.
microsoft-visio shapes master
I am very very beginner at Visio and I have been struggling days on something which is probably very basic.
I have a set of data defined in an excel file, this way:
Name,Age,City
Paul,23,Paris
Jacques,55,London
Thomas,67,New York
I am trying to create a master composed of 3 rectangles, one for the field "Name", one for "Age" and one for "City". Each rectangle is supposed to contain one of the field in the above file.
Then I would like to create shapes of this master populated with data when I import data from my excel file.
Preferably I would like to avoid using VBA.
Is this realistic with Visio? Can someone provide with a good method to realize this?
Edit
Maybe my question might be simplified as this one: is there a way to link the data of one SHAPE to another SHAPE?
In other words, I create a shape A and associate data (name, age) to it. Then I create a shape B, and I would like B's data to always be equal to A's data, e.g if I change A.name, B.name also changes.
I've tried many different manipulations without success.
microsoft-visio shapes master
microsoft-visio shapes master
edited Feb 7 at 5:38
Ookami
asked Feb 4 at 6:00
OokamiOokami
12
12
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I eventually followed this solution. Basically:
- Group the shapes
- Set the data for the group (not for an individual shape)
- Open the "Open Group" editor (Right Click -> Group -> Open Group)
- Use the "Insert" feature on each shape, but instead of "Shape Data", a Custom Formula is needed.
The link above is very clear so I recommend it for people having the same issue.
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
});
}
});
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%2f1401737%2fmicrosoft-visio-define-data-position-on-master-shape%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
I eventually followed this solution. Basically:
- Group the shapes
- Set the data for the group (not for an individual shape)
- Open the "Open Group" editor (Right Click -> Group -> Open Group)
- Use the "Insert" feature on each shape, but instead of "Shape Data", a Custom Formula is needed.
The link above is very clear so I recommend it for people having the same issue.
add a comment |
I eventually followed this solution. Basically:
- Group the shapes
- Set the data for the group (not for an individual shape)
- Open the "Open Group" editor (Right Click -> Group -> Open Group)
- Use the "Insert" feature on each shape, but instead of "Shape Data", a Custom Formula is needed.
The link above is very clear so I recommend it for people having the same issue.
add a comment |
I eventually followed this solution. Basically:
- Group the shapes
- Set the data for the group (not for an individual shape)
- Open the "Open Group" editor (Right Click -> Group -> Open Group)
- Use the "Insert" feature on each shape, but instead of "Shape Data", a Custom Formula is needed.
The link above is very clear so I recommend it for people having the same issue.
I eventually followed this solution. Basically:
- Group the shapes
- Set the data for the group (not for an individual shape)
- Open the "Open Group" editor (Right Click -> Group -> Open Group)
- Use the "Insert" feature on each shape, but instead of "Shape Data", a Custom Formula is needed.
The link above is very clear so I recommend it for people having the same issue.
answered Feb 8 at 2:39
OokamiOokami
12
12
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%2f1401737%2fmicrosoft-visio-define-data-position-on-master-shape%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