excel chart data labels failing to apply to all series
if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps 'value' based data labels on all series
however, if I then uncheck the 'value' checkbox and select 'labels' instead, it only applies it to one series at random
is there any way to force it to apply to all?
microsoft-excel microsoft-excel-2010 formatting charts
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
add a comment |
if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps 'value' based data labels on all series
however, if I then uncheck the 'value' checkbox and select 'labels' instead, it only applies it to one series at random
is there any way to force it to apply to all?
microsoft-excel microsoft-excel-2010 formatting charts
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
I believe only the default 'value' is applied to all series, and only when you first invoke it. Subsequent changes muyst be applied to each series in turn.
– Jon Peltier
Nov 28 '14 at 16:45
this is surely a BUG then?
– adolf garlic
Dec 2 '14 at 8:31
No, it's a default setting which probably is appropriate for most cases. Wouldn't it be redundant to label every point in a series with the series name?
– Jon Peltier
Dec 2 '14 at 23:49
I don't mean with the same series. Ok. So when I perform the actions above, it automatically adds values to every single point on every single series showing the data value in question, what I'm saying is, why, when I decide to show the SERIES name instead of values, it only applies it to a single series and not all of them. What you're left with is a bunch of series, one of which has its series name as the label, the rest of which have values as the label. It looks messy and requires a lot of manual effort to clean it up
– adolf garlic
Dec 3 '14 at 9:52
The designers decided to expose the option of what to show only when a single series of data labels (or single data label) is selected.
– Jon Peltier
Dec 4 '14 at 14:14
add a comment |
if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps 'value' based data labels on all series
however, if I then uncheck the 'value' checkbox and select 'labels' instead, it only applies it to one series at random
is there any way to force it to apply to all?
microsoft-excel microsoft-excel-2010 formatting charts
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps 'value' based data labels on all series
however, if I then uncheck the 'value' checkbox and select 'labels' instead, it only applies it to one series at random
is there any way to force it to apply to all?
microsoft-excel microsoft-excel-2010 formatting charts
microsoft-excel microsoft-excel-2010 formatting charts
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
asked Nov 27 '14 at 13:03
adolf garlicadolf garlic
87582542
87582542
I believe only the default 'value' is applied to all series, and only when you first invoke it. Subsequent changes muyst be applied to each series in turn.
– Jon Peltier
Nov 28 '14 at 16:45
this is surely a BUG then?
– adolf garlic
Dec 2 '14 at 8:31
No, it's a default setting which probably is appropriate for most cases. Wouldn't it be redundant to label every point in a series with the series name?
– Jon Peltier
Dec 2 '14 at 23:49
I don't mean with the same series. Ok. So when I perform the actions above, it automatically adds values to every single point on every single series showing the data value in question, what I'm saying is, why, when I decide to show the SERIES name instead of values, it only applies it to a single series and not all of them. What you're left with is a bunch of series, one of which has its series name as the label, the rest of which have values as the label. It looks messy and requires a lot of manual effort to clean it up
– adolf garlic
Dec 3 '14 at 9:52
The designers decided to expose the option of what to show only when a single series of data labels (or single data label) is selected.
– Jon Peltier
Dec 4 '14 at 14:14
add a comment |
I believe only the default 'value' is applied to all series, and only when you first invoke it. Subsequent changes muyst be applied to each series in turn.
– Jon Peltier
Nov 28 '14 at 16:45
this is surely a BUG then?
– adolf garlic
Dec 2 '14 at 8:31
No, it's a default setting which probably is appropriate for most cases. Wouldn't it be redundant to label every point in a series with the series name?
– Jon Peltier
Dec 2 '14 at 23:49
I don't mean with the same series. Ok. So when I perform the actions above, it automatically adds values to every single point on every single series showing the data value in question, what I'm saying is, why, when I decide to show the SERIES name instead of values, it only applies it to a single series and not all of them. What you're left with is a bunch of series, one of which has its series name as the label, the rest of which have values as the label. It looks messy and requires a lot of manual effort to clean it up
– adolf garlic
Dec 3 '14 at 9:52
The designers decided to expose the option of what to show only when a single series of data labels (or single data label) is selected.
– Jon Peltier
Dec 4 '14 at 14:14
I believe only the default 'value' is applied to all series, and only when you first invoke it. Subsequent changes muyst be applied to each series in turn.
– Jon Peltier
Nov 28 '14 at 16:45
I believe only the default 'value' is applied to all series, and only when you first invoke it. Subsequent changes muyst be applied to each series in turn.
– Jon Peltier
Nov 28 '14 at 16:45
this is surely a BUG then?
– adolf garlic
Dec 2 '14 at 8:31
this is surely a BUG then?
– adolf garlic
Dec 2 '14 at 8:31
No, it's a default setting which probably is appropriate for most cases. Wouldn't it be redundant to label every point in a series with the series name?
– Jon Peltier
Dec 2 '14 at 23:49
No, it's a default setting which probably is appropriate for most cases. Wouldn't it be redundant to label every point in a series with the series name?
– Jon Peltier
Dec 2 '14 at 23:49
I don't mean with the same series. Ok. So when I perform the actions above, it automatically adds values to every single point on every single series showing the data value in question, what I'm saying is, why, when I decide to show the SERIES name instead of values, it only applies it to a single series and not all of them. What you're left with is a bunch of series, one of which has its series name as the label, the rest of which have values as the label. It looks messy and requires a lot of manual effort to clean it up
– adolf garlic
Dec 3 '14 at 9:52
I don't mean with the same series. Ok. So when I perform the actions above, it automatically adds values to every single point on every single series showing the data value in question, what I'm saying is, why, when I decide to show the SERIES name instead of values, it only applies it to a single series and not all of them. What you're left with is a bunch of series, one of which has its series name as the label, the rest of which have values as the label. It looks messy and requires a lot of manual effort to clean it up
– adolf garlic
Dec 3 '14 at 9:52
The designers decided to expose the option of what to show only when a single series of data labels (or single data label) is selected.
– Jon Peltier
Dec 4 '14 at 14:14
The designers decided to expose the option of what to show only when a single series of data labels (or single data label) is selected.
– Jon Peltier
Dec 4 '14 at 14:14
add a comment |
1 Answer
1
active
oldest
votes
I'm having the same problem. The only way to create the pivot table it seems is to select the entire list of individual values (names) as well as the Series Value (another name) that has a drop down list with all the Individual Values (names) in it, otherwise it won't populate the pivot table at all.
Then when you connect the graph to the pivot table, it chooses the legend titles as numerical values for each Individual Value automatically (what should be a name), and when you choose the series value as an alternative, it creates a dropdown or all the names in the series, not the actual series name. There is no programmed option to change the numerical legend title values to title values using corresponding names.
This seems to me to be a bug or a programming failure to clear up the code (probably being bugged by the drop down list and the programmer's failure to hide the numerical coding of individual items and replace it with names). I get that the programmers may have an automatic selection, but it is stupid to use numbers for things that are identified in every other part of the data as a name.
I just wish they would fix it because a budget template seems it would be a pretty commonly used template and that is the macro I used to create my own form. I like to think I'm smart, but I'm sure I'm not smart enough to break coding as a regular user.
The original pivot table in the created form has actually never worked from the original template that I copied from the start. When I added new lookup lists, the original pivot table failed to recognize the updated source, necessitating creating a new pivot table. Now the graph fails to pull actual names instead of number values. (Unless I have to recreate the graph too?)
But then what's the point in a budget template if you can't customize it?
(Or at least include a tutorial or disclaimer. This has been a huge time-waster.)
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
Welcome to SuperUser! This is not a forum and you posted this as an answer. It looks like this post might contain an answer but it's not super clear. Can you edit your answer to be a clear step-by-step to always get the desired result? I understand that the issue is frustrating but the conjecture doesn't help other people solve this problem.
– HackSlash
Feb 6 at 20:42
When you edit this to clarify the actionable, usable answer, please cut out the opinion (i.e., the last four paragraphs).
– Scott
Feb 6 at 22:08
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%2f845696%2fexcel-chart-data-labels-failing-to-apply-to-all-series%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'm having the same problem. The only way to create the pivot table it seems is to select the entire list of individual values (names) as well as the Series Value (another name) that has a drop down list with all the Individual Values (names) in it, otherwise it won't populate the pivot table at all.
Then when you connect the graph to the pivot table, it chooses the legend titles as numerical values for each Individual Value automatically (what should be a name), and when you choose the series value as an alternative, it creates a dropdown or all the names in the series, not the actual series name. There is no programmed option to change the numerical legend title values to title values using corresponding names.
This seems to me to be a bug or a programming failure to clear up the code (probably being bugged by the drop down list and the programmer's failure to hide the numerical coding of individual items and replace it with names). I get that the programmers may have an automatic selection, but it is stupid to use numbers for things that are identified in every other part of the data as a name.
I just wish they would fix it because a budget template seems it would be a pretty commonly used template and that is the macro I used to create my own form. I like to think I'm smart, but I'm sure I'm not smart enough to break coding as a regular user.
The original pivot table in the created form has actually never worked from the original template that I copied from the start. When I added new lookup lists, the original pivot table failed to recognize the updated source, necessitating creating a new pivot table. Now the graph fails to pull actual names instead of number values. (Unless I have to recreate the graph too?)
But then what's the point in a budget template if you can't customize it?
(Or at least include a tutorial or disclaimer. This has been a huge time-waster.)
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
Welcome to SuperUser! This is not a forum and you posted this as an answer. It looks like this post might contain an answer but it's not super clear. Can you edit your answer to be a clear step-by-step to always get the desired result? I understand that the issue is frustrating but the conjecture doesn't help other people solve this problem.
– HackSlash
Feb 6 at 20:42
When you edit this to clarify the actionable, usable answer, please cut out the opinion (i.e., the last four paragraphs).
– Scott
Feb 6 at 22:08
add a comment |
I'm having the same problem. The only way to create the pivot table it seems is to select the entire list of individual values (names) as well as the Series Value (another name) that has a drop down list with all the Individual Values (names) in it, otherwise it won't populate the pivot table at all.
Then when you connect the graph to the pivot table, it chooses the legend titles as numerical values for each Individual Value automatically (what should be a name), and when you choose the series value as an alternative, it creates a dropdown or all the names in the series, not the actual series name. There is no programmed option to change the numerical legend title values to title values using corresponding names.
This seems to me to be a bug or a programming failure to clear up the code (probably being bugged by the drop down list and the programmer's failure to hide the numerical coding of individual items and replace it with names). I get that the programmers may have an automatic selection, but it is stupid to use numbers for things that are identified in every other part of the data as a name.
I just wish they would fix it because a budget template seems it would be a pretty commonly used template and that is the macro I used to create my own form. I like to think I'm smart, but I'm sure I'm not smart enough to break coding as a regular user.
The original pivot table in the created form has actually never worked from the original template that I copied from the start. When I added new lookup lists, the original pivot table failed to recognize the updated source, necessitating creating a new pivot table. Now the graph fails to pull actual names instead of number values. (Unless I have to recreate the graph too?)
But then what's the point in a budget template if you can't customize it?
(Or at least include a tutorial or disclaimer. This has been a huge time-waster.)
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
Welcome to SuperUser! This is not a forum and you posted this as an answer. It looks like this post might contain an answer but it's not super clear. Can you edit your answer to be a clear step-by-step to always get the desired result? I understand that the issue is frustrating but the conjecture doesn't help other people solve this problem.
– HackSlash
Feb 6 at 20:42
When you edit this to clarify the actionable, usable answer, please cut out the opinion (i.e., the last four paragraphs).
– Scott
Feb 6 at 22:08
add a comment |
I'm having the same problem. The only way to create the pivot table it seems is to select the entire list of individual values (names) as well as the Series Value (another name) that has a drop down list with all the Individual Values (names) in it, otherwise it won't populate the pivot table at all.
Then when you connect the graph to the pivot table, it chooses the legend titles as numerical values for each Individual Value automatically (what should be a name), and when you choose the series value as an alternative, it creates a dropdown or all the names in the series, not the actual series name. There is no programmed option to change the numerical legend title values to title values using corresponding names.
This seems to me to be a bug or a programming failure to clear up the code (probably being bugged by the drop down list and the programmer's failure to hide the numerical coding of individual items and replace it with names). I get that the programmers may have an automatic selection, but it is stupid to use numbers for things that are identified in every other part of the data as a name.
I just wish they would fix it because a budget template seems it would be a pretty commonly used template and that is the macro I used to create my own form. I like to think I'm smart, but I'm sure I'm not smart enough to break coding as a regular user.
The original pivot table in the created form has actually never worked from the original template that I copied from the start. When I added new lookup lists, the original pivot table failed to recognize the updated source, necessitating creating a new pivot table. Now the graph fails to pull actual names instead of number values. (Unless I have to recreate the graph too?)
But then what's the point in a budget template if you can't customize it?
(Or at least include a tutorial or disclaimer. This has been a huge time-waster.)
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
I'm having the same problem. The only way to create the pivot table it seems is to select the entire list of individual values (names) as well as the Series Value (another name) that has a drop down list with all the Individual Values (names) in it, otherwise it won't populate the pivot table at all.
Then when you connect the graph to the pivot table, it chooses the legend titles as numerical values for each Individual Value automatically (what should be a name), and when you choose the series value as an alternative, it creates a dropdown or all the names in the series, not the actual series name. There is no programmed option to change the numerical legend title values to title values using corresponding names.
This seems to me to be a bug or a programming failure to clear up the code (probably being bugged by the drop down list and the programmer's failure to hide the numerical coding of individual items and replace it with names). I get that the programmers may have an automatic selection, but it is stupid to use numbers for things that are identified in every other part of the data as a name.
I just wish they would fix it because a budget template seems it would be a pretty commonly used template and that is the macro I used to create my own form. I like to think I'm smart, but I'm sure I'm not smart enough to break coding as a regular user.
The original pivot table in the created form has actually never worked from the original template that I copied from the start. When I added new lookup lists, the original pivot table failed to recognize the updated source, necessitating creating a new pivot table. Now the graph fails to pull actual names instead of number values. (Unless I have to recreate the graph too?)
But then what's the point in a budget template if you can't customize it?
(Or at least include a tutorial or disclaimer. This has been a huge time-waster.)
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
answered Feb 6 at 20:02
Adam HalvorsenAdam Halvorsen
1
1
Welcome to SuperUser! This is not a forum and you posted this as an answer. It looks like this post might contain an answer but it's not super clear. Can you edit your answer to be a clear step-by-step to always get the desired result? I understand that the issue is frustrating but the conjecture doesn't help other people solve this problem.
– HackSlash
Feb 6 at 20:42
When you edit this to clarify the actionable, usable answer, please cut out the opinion (i.e., the last four paragraphs).
– Scott
Feb 6 at 22:08
add a comment |
Welcome to SuperUser! This is not a forum and you posted this as an answer. It looks like this post might contain an answer but it's not super clear. Can you edit your answer to be a clear step-by-step to always get the desired result? I understand that the issue is frustrating but the conjecture doesn't help other people solve this problem.
– HackSlash
Feb 6 at 20:42
When you edit this to clarify the actionable, usable answer, please cut out the opinion (i.e., the last four paragraphs).
– Scott
Feb 6 at 22:08
Welcome to SuperUser! This is not a forum and you posted this as an answer. It looks like this post might contain an answer but it's not super clear. Can you edit your answer to be a clear step-by-step to always get the desired result? I understand that the issue is frustrating but the conjecture doesn't help other people solve this problem.
– HackSlash
Feb 6 at 20:42
Welcome to SuperUser! This is not a forum and you posted this as an answer. It looks like this post might contain an answer but it's not super clear. Can you edit your answer to be a clear step-by-step to always get the desired result? I understand that the issue is frustrating but the conjecture doesn't help other people solve this problem.
– HackSlash
Feb 6 at 20:42
When you edit this to clarify the actionable, usable answer, please cut out the opinion (i.e., the last four paragraphs).
– Scott
Feb 6 at 22:08
When you edit this to clarify the actionable, usable answer, please cut out the opinion (i.e., the last four paragraphs).
– Scott
Feb 6 at 22:08
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%2f845696%2fexcel-chart-data-labels-failing-to-apply-to-all-series%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 believe only the default 'value' is applied to all series, and only when you first invoke it. Subsequent changes muyst be applied to each series in turn.
– Jon Peltier
Nov 28 '14 at 16:45
this is surely a BUG then?
– adolf garlic
Dec 2 '14 at 8:31
No, it's a default setting which probably is appropriate for most cases. Wouldn't it be redundant to label every point in a series with the series name?
– Jon Peltier
Dec 2 '14 at 23:49
I don't mean with the same series. Ok. So when I perform the actions above, it automatically adds values to every single point on every single series showing the data value in question, what I'm saying is, why, when I decide to show the SERIES name instead of values, it only applies it to a single series and not all of them. What you're left with is a bunch of series, one of which has its series name as the label, the rest of which have values as the label. It looks messy and requires a lot of manual effort to clean it up
– adolf garlic
Dec 3 '14 at 9:52
The designers decided to expose the option of what to show only when a single series of data labels (or single data label) is selected.
– Jon Peltier
Dec 4 '14 at 14:14