Excel Charts Showing Blank and with Data as Header
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm having an issue creating some tables.
What I want to do is create a tab with a series of charts within it to represent distributions of various data point from specific columns in a primary/master tab.
The issue I am having is that when I select the data I want the chart to have, the selected data is positioned in the 'Chart Title' position and the chart itself shows as blank.
I also then tried selecting the 'Plot Area' object with the wider chart box and reselecting the data but that does not make any difference.
I am using Excel on a Macbook.
I've attached some screenshots below, any more detail needed, please ask.
Sample of Data:
Malformed Chart
Data Selection
When I right click on the 'Plot Area' placeholder and select the data again I just end up with this...
microsoft-excel mac charts
|
show 2 more comments
I'm having an issue creating some tables.
What I want to do is create a tab with a series of charts within it to represent distributions of various data point from specific columns in a primary/master tab.
The issue I am having is that when I select the data I want the chart to have, the selected data is positioned in the 'Chart Title' position and the chart itself shows as blank.
I also then tried selecting the 'Plot Area' object with the wider chart box and reselecting the data but that does not make any difference.
I am using Excel on a Macbook.
I've attached some screenshots below, any more detail needed, please ask.
Sample of Data:
Malformed Chart
Data Selection
When I right click on the 'Plot Area' placeholder and select the data again I just end up with this...
microsoft-excel mac charts
Try switching the ranges for "Name" and "Y values" around
– cybernetic.nomad
Mar 6 at 16:12
That gets better values but the chart is still blank
– Rich C
Mar 6 at 16:24
Can you post sample data? can you get a chart working with a small table (say 2x3 cells)?
– cybernetic.nomad
Mar 6 at 16:25
2
If you have no numbers, then no wonder the chart is blank. What are you trying to accomplish?
– cybernetic.nomad
Mar 6 at 16:29
2
Get a list of all the types (with no duplication), then useCOUNTIF
to get the numbers
– cybernetic.nomad
Mar 6 at 16:32
|
show 2 more comments
I'm having an issue creating some tables.
What I want to do is create a tab with a series of charts within it to represent distributions of various data point from specific columns in a primary/master tab.
The issue I am having is that when I select the data I want the chart to have, the selected data is positioned in the 'Chart Title' position and the chart itself shows as blank.
I also then tried selecting the 'Plot Area' object with the wider chart box and reselecting the data but that does not make any difference.
I am using Excel on a Macbook.
I've attached some screenshots below, any more detail needed, please ask.
Sample of Data:
Malformed Chart
Data Selection
When I right click on the 'Plot Area' placeholder and select the data again I just end up with this...
microsoft-excel mac charts
I'm having an issue creating some tables.
What I want to do is create a tab with a series of charts within it to represent distributions of various data point from specific columns in a primary/master tab.
The issue I am having is that when I select the data I want the chart to have, the selected data is positioned in the 'Chart Title' position and the chart itself shows as blank.
I also then tried selecting the 'Plot Area' object with the wider chart box and reselecting the data but that does not make any difference.
I am using Excel on a Macbook.
I've attached some screenshots below, any more detail needed, please ask.
Sample of Data:
Malformed Chart
Data Selection
When I right click on the 'Plot Area' placeholder and select the data again I just end up with this...
microsoft-excel mac charts
microsoft-excel mac charts
edited Mar 6 at 16:28
Rich C
asked Mar 6 at 15:39
Rich CRich C
1258
1258
Try switching the ranges for "Name" and "Y values" around
– cybernetic.nomad
Mar 6 at 16:12
That gets better values but the chart is still blank
– Rich C
Mar 6 at 16:24
Can you post sample data? can you get a chart working with a small table (say 2x3 cells)?
– cybernetic.nomad
Mar 6 at 16:25
2
If you have no numbers, then no wonder the chart is blank. What are you trying to accomplish?
– cybernetic.nomad
Mar 6 at 16:29
2
Get a list of all the types (with no duplication), then useCOUNTIF
to get the numbers
– cybernetic.nomad
Mar 6 at 16:32
|
show 2 more comments
Try switching the ranges for "Name" and "Y values" around
– cybernetic.nomad
Mar 6 at 16:12
That gets better values but the chart is still blank
– Rich C
Mar 6 at 16:24
Can you post sample data? can you get a chart working with a small table (say 2x3 cells)?
– cybernetic.nomad
Mar 6 at 16:25
2
If you have no numbers, then no wonder the chart is blank. What are you trying to accomplish?
– cybernetic.nomad
Mar 6 at 16:29
2
Get a list of all the types (with no duplication), then useCOUNTIF
to get the numbers
– cybernetic.nomad
Mar 6 at 16:32
Try switching the ranges for "Name" and "Y values" around
– cybernetic.nomad
Mar 6 at 16:12
Try switching the ranges for "Name" and "Y values" around
– cybernetic.nomad
Mar 6 at 16:12
That gets better values but the chart is still blank
– Rich C
Mar 6 at 16:24
That gets better values but the chart is still blank
– Rich C
Mar 6 at 16:24
Can you post sample data? can you get a chart working with a small table (say 2x3 cells)?
– cybernetic.nomad
Mar 6 at 16:25
Can you post sample data? can you get a chart working with a small table (say 2x3 cells)?
– cybernetic.nomad
Mar 6 at 16:25
2
2
If you have no numbers, then no wonder the chart is blank. What are you trying to accomplish?
– cybernetic.nomad
Mar 6 at 16:29
If you have no numbers, then no wonder the chart is blank. What are you trying to accomplish?
– cybernetic.nomad
Mar 6 at 16:29
2
2
Get a list of all the types (with no duplication), then use
COUNTIF
to get the numbers– cybernetic.nomad
Mar 6 at 16:32
Get a list of all the types (with no duplication), then use
COUNTIF
to get the numbers– cybernetic.nomad
Mar 6 at 16:32
|
show 2 more comments
1 Answer
1
active
oldest
votes
You need to make a pivot table of your column of data. Put Social Landlord into the rows area and also into the values area. Since it's text, Excel should default to a count of Social Landlord in the values area. Your pivot table will be two columns, with the text labels in the first column and the counts in the second. If you want, you can sort it and make a horizontal bar chart from the pivot table.
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%2f1411840%2fexcel-charts-showing-blank-and-with-data-as-header%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
You need to make a pivot table of your column of data. Put Social Landlord into the rows area and also into the values area. Since it's text, Excel should default to a count of Social Landlord in the values area. Your pivot table will be two columns, with the text labels in the first column and the counts in the second. If you want, you can sort it and make a horizontal bar chart from the pivot table.
add a comment |
You need to make a pivot table of your column of data. Put Social Landlord into the rows area and also into the values area. Since it's text, Excel should default to a count of Social Landlord in the values area. Your pivot table will be two columns, with the text labels in the first column and the counts in the second. If you want, you can sort it and make a horizontal bar chart from the pivot table.
add a comment |
You need to make a pivot table of your column of data. Put Social Landlord into the rows area and also into the values area. Since it's text, Excel should default to a count of Social Landlord in the values area. Your pivot table will be two columns, with the text labels in the first column and the counts in the second. If you want, you can sort it and make a horizontal bar chart from the pivot table.
You need to make a pivot table of your column of data. Put Social Landlord into the rows area and also into the values area. Since it's text, Excel should default to a count of Social Landlord in the values area. Your pivot table will be two columns, with the text labels in the first column and the counts in the second. If you want, you can sort it and make a horizontal bar chart from the pivot table.
answered Apr 5 at 4:07
Jon PeltierJon Peltier
2,9621420
2,9621420
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%2f1411840%2fexcel-charts-showing-blank-and-with-data-as-header%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
Try switching the ranges for "Name" and "Y values" around
– cybernetic.nomad
Mar 6 at 16:12
That gets better values but the chart is still blank
– Rich C
Mar 6 at 16:24
Can you post sample data? can you get a chart working with a small table (say 2x3 cells)?
– cybernetic.nomad
Mar 6 at 16:25
2
If you have no numbers, then no wonder the chart is blank. What are you trying to accomplish?
– cybernetic.nomad
Mar 6 at 16:29
2
Get a list of all the types (with no duplication), then use
COUNTIF
to get the numbers– cybernetic.nomad
Mar 6 at 16:32