Chart options missing in excel 2016
I have Excel 2016 and I cannot use the statistics charts because that, along with two other options are missing in the "Insert" tab.
This is what a normal Excel chart options area looks like:
However, mine looks like this:
How do I get the other options so I can add a histogram?
microsoft-excel charts
asked Jan 6 at 16:36
user4757174
3526
add a comment |
I have Excel 2016 and I cannot use the statistics charts because that, along with two other options are missing in the "Insert" tab.
This is what a normal Excel chart options area looks like:
However, mine looks like this:
How do I get the other options so I can add a histogram?
microsoft-excel charts
asked Jan 6 at 16:36
user4757174
3526
It might be that some options are hidden because of limited space. Try dragging the vertical line (to the right of Pivot Chart) to the right, and maybe the missing options will appear.
– Bandersnatch
Jan 6 at 16:44
The line cannot be dragged. Maximizing the window doesn't help either.
– user4757174
Jan 6 at 16:46
Can you find Histograms under Recommended Charts>All Charts? This will tell you if you're missing the charts entirely, or just a ribbon shortcut to them.
– dav
Jan 8 at 13:05
For some reason, you're missing all of the new chart types. Treemap, Sunburst, Histogram, Pareto, Boxplot, Waterfall. What specific version of Excel? Under the red Office logo in File > Account, it says Microsoft Office [Something Something] 2016: what's in brackets? Also, below that it says version something and build something: what are these numbers? And what version of Windows?
– Jon Peltier
Jan 13 at 3:24
add a comment |
I have Excel 2016 and I cannot use the statistics charts because that, along with two other options are missing in the "Insert" tab.
This is what a normal Excel chart options area looks like:
However, mine looks like this:
How do I get the other options so I can add a histogram?
microsoft-excel charts
asked Jan 6 at 16:36
user4757174
3526
I have Excel 2016 and I cannot use the statistics charts because that, along with two other options are missing in the "Insert" tab.
This is what a normal Excel chart options area looks like:
However, mine looks like this:
How do I get the other options so I can add a histogram?
microsoft-excel charts
microsoft-excel charts
asked Jan 6 at 16:36
user4757174
3526
asked Jan 6 at 16:36
user4757174
3526
asked Jan 6 at 16:36
user4757174
3526
asked Jan 6 at 16:36
user4757174
3526
asked Jan 6 at 16:36
user4757174
3526
3526
It might be that some options are hidden because of limited space. Try dragging the vertical line (to the right of Pivot Chart) to the right, and maybe the missing options will appear.
– Bandersnatch
Jan 6 at 16:44
The line cannot be dragged. Maximizing the window doesn't help either.
– user4757174
Jan 6 at 16:46
Can you find Histograms under Recommended Charts>All Charts? This will tell you if you're missing the charts entirely, or just a ribbon shortcut to them.
– dav
Jan 8 at 13:05
For some reason, you're missing all of the new chart types. Treemap, Sunburst, Histogram, Pareto, Boxplot, Waterfall. What specific version of Excel? Under the red Office logo in File > Account, it says Microsoft Office [Something Something] 2016: what's in brackets? Also, below that it says version something and build something: what are these numbers? And what version of Windows?
– Jon Peltier
Jan 13 at 3:24
add a comment |
It might be that some options are hidden because of limited space. Try dragging the vertical line (to the right of Pivot Chart) to the right, and maybe the missing options will appear.
– Bandersnatch
Jan 6 at 16:44
The line cannot be dragged. Maximizing the window doesn't help either.
– user4757174
Jan 6 at 16:46
Can you find Histograms under Recommended Charts>All Charts? This will tell you if you're missing the charts entirely, or just a ribbon shortcut to them.
– dav
Jan 8 at 13:05
For some reason, you're missing all of the new chart types. Treemap, Sunburst, Histogram, Pareto, Boxplot, Waterfall. What specific version of Excel? Under the red Office logo in File > Account, it says Microsoft Office [Something Something] 2016: what's in brackets? Also, below that it says version something and build something: what are these numbers? And what version of Windows?
– Jon Peltier
Jan 13 at 3:24
It might be that some options are hidden because of limited space. Try dragging the vertical line (to the right of Pivot Chart) to the right, and maybe the missing options will appear.
– Bandersnatch
Jan 6 at 16:44
It might be that some options are hidden because of limited space. Try dragging the vertical line (to the right of Pivot Chart) to the right, and maybe the missing options will appear.
– Bandersnatch
Jan 6 at 16:44
The line cannot be dragged. Maximizing the window doesn't help either.
– user4757174
Jan 6 at 16:46
The line cannot be dragged. Maximizing the window doesn't help either.
– user4757174
Jan 6 at 16:46
Can you find Histograms under Recommended Charts>All Charts? This will tell you if you're missing the charts entirely, or just a ribbon shortcut to them.
– dav
Jan 8 at 13:05
Can you find Histograms under Recommended Charts>All Charts? This will tell you if you're missing the charts entirely, or just a ribbon shortcut to them.
– dav
Jan 8 at 13:05
For some reason, you're missing all of the new chart types. Treemap, Sunburst, Histogram, Pareto, Boxplot, Waterfall. What specific version of Excel? Under the red Office logo in File > Account, it says Microsoft Office [Something Something] 2016: what's in brackets? Also, below that it says version something and build something: what are these numbers? And what version of Windows?
– Jon Peltier
Jan 13 at 3:24
For some reason, you're missing all of the new chart types. Treemap, Sunburst, Histogram, Pareto, Boxplot, Waterfall. What specific version of Excel? Under the red Office logo in File > Account, it says Microsoft Office [Something Something] 2016: what's in brackets? Also, below that it says version something and build something: what are these numbers? And what version of Windows?
– Jon Peltier
Jan 13 at 3:24
add a comment |
8 Answers
8
active
oldest
votes
In Excel go to File / Options / Add-Ins
Select Analysis ToolPak (it should be in the "Inacticve Application Add-ins")
Click Go at the bottom.
Check the box at Analysis ToolPak and click OK
Close and Re-open Excel again and you should have the histogram option.
This is working for me in Excel 365.
edited Feb 5 at 13:49
PeterH
3,44332246
answered Feb 5 at 9:48
electricar
211
add a comment |
Click that little arrow in the corner of the tab group (just to the right and below the PivotChart option). This should open a new form/window with all the options.
answered Jan 6 at 20:14
AJD
25628
There is no histogram in those options
– user4757174
Jan 7 at 6:58
add a comment |
Please check if you add more commands to the Insert tab, try to remove them.
Then try to reset Ribbon option in Excel, please go to this path:
C:UsersUser NameAppDataRoamingMicrosoftExcel
Please rename the file Excel16.xlb to Excel16.xlb.old then reopen Excel and check the result.
answered Jan 8 at 1:40
Lee
86427
Excel15.xlb is probably irrelevant, since Excel 2016 is Excel16.
– Jon Peltier
Jan 15 at 3:08
OH,YES~My mistake.
– Lee
Jan 15 at 6:02
add a comment |
Make sure you haven't opened a sheet in compatibility view. If you have, go to the file menu and click convert. This will give you back these charts on this sheet
answered May 15 at 0:30
Dub Ambman
1
add a comment |
You need to get rid of compatibility view. Save as the file and reopen the new file. Should work now.
answered Jun 12 at 6:25
cryinginclass
1
add a comment |
Select "File", "Save As" and save the file as Excel Workbook (.xlsx) or some other recent versioning. If the workbook is saved as an older version of Excel, i.e. Excel 97-2003 (.xls), the Analysis Toolpak add-in will not work.
answered Jul 3 at 19:23
EByrd
1
add a comment |
I solved the same problem just now: The file was saved as .xls and not .xlsx, so excel 2016 features did not apply for that file and automatically these features are disabled.
BTW, in my case it was noted as "Compitability mode" at the top of the screen.
So:
1. Save the file as .xlsx
2. Close it.
3. Open the .xlsx file
And voila statistical charts are there again.
answered Dec 13 at 10:21
Alon
1
2
Welcome to Super User, and kudos for solving your problem. However, EByrd posted this solution some months ago. The intention is that each answer should provide a solution that hasn't already been contributed.
– fixer1234
Dec 13 at 10:34
add a comment |
- had the exact same problem, I changed the compatibility view and it fixed everything. If you go to the file menu and click convert this will give you back the charts you are missing.
*
answered Jun 23 at 5:17
num
1
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%2f1283122%2fchart-options-missing-in-excel-2016%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
8 Answers
8
active
oldest
votes
8 Answers
8
active
oldest
votes
active
oldest
votes
active
oldest
votes
In Excel go to File / Options / Add-Ins
Select Analysis ToolPak (it should be in the "Inacticve Application Add-ins")
Click Go at the bottom.
Check the box at Analysis ToolPak and click OK
Close and Re-open Excel again and you should have the histogram option.
This is working for me in Excel 365.
edited Feb 5 at 13:49
PeterH
3,44332246
answered Feb 5 at 9:48
electricar
211
add a comment |
In Excel go to File / Options / Add-Ins
Select Analysis ToolPak (it should be in the "Inacticve Application Add-ins")
Click Go at the bottom.
Check the box at Analysis ToolPak and click OK
Close and Re-open Excel again and you should have the histogram option.
This is working for me in Excel 365.
edited Feb 5 at 13:49
PeterH
3,44332246
answered Feb 5 at 9:48
electricar
211
add a comment |
In Excel go to File / Options / Add-Ins
Select Analysis ToolPak (it should be in the "Inacticve Application Add-ins")
Click Go at the bottom.
Check the box at Analysis ToolPak and click OK
Close and Re-open Excel again and you should have the histogram option.
This is working for me in Excel 365.
edited Feb 5 at 13:49
PeterH
3,44332246
answered Feb 5 at 9:48
electricar
211
In Excel go to File / Options / Add-Ins
Select Analysis ToolPak (it should be in the "Inacticve Application Add-ins")
Click Go at the bottom.
Check the box at Analysis ToolPak and click OK
Close and Re-open Excel again and you should have the histogram option.
This is working for me in Excel 365.
edited Feb 5 at 13:49
PeterH
3,44332246
answered Feb 5 at 9:48
electricar
211
edited Feb 5 at 13:49
PeterH
3,44332246
edited Feb 5 at 13:49
PeterH
3,44332246
edited Feb 5 at 13:49
PeterH
3,44332246
3,44332246
answered Feb 5 at 9:48
electricar
211
answered Feb 5 at 9:48
electricar
211
answered Feb 5 at 9:48
electricar
211
211
add a comment |
add a comment |
Click that little arrow in the corner of the tab group (just to the right and below the PivotChart option). This should open a new form/window with all the options.
answered Jan 6 at 20:14
AJD
25628
There is no histogram in those options
– user4757174
Jan 7 at 6:58
add a comment |
Click that little arrow in the corner of the tab group (just to the right and below the PivotChart option). This should open a new form/window with all the options.
answered Jan 6 at 20:14
AJD
25628
There is no histogram in those options
– user4757174
Jan 7 at 6:58
add a comment |
Click that little arrow in the corner of the tab group (just to the right and below the PivotChart option). This should open a new form/window with all the options.
answered Jan 6 at 20:14
AJD
25628
Click that little arrow in the corner of the tab group (just to the right and below the PivotChart option). This should open a new form/window with all the options.
answered Jan 6 at 20:14
AJD
25628
answered Jan 6 at 20:14
AJD
25628
answered Jan 6 at 20:14
AJD
25628
answered Jan 6 at 20:14
AJD
25628
25628
There is no histogram in those options
– user4757174
Jan 7 at 6:58
add a comment |
There is no histogram in those options
– user4757174
Jan 7 at 6:58
There is no histogram in those options
– user4757174
Jan 7 at 6:58
There is no histogram in those options
– user4757174
Jan 7 at 6:58
add a comment |
Please check if you add more commands to the Insert tab, try to remove them.
Then try to reset Ribbon option in Excel, please go to this path:
C:UsersUser NameAppDataRoamingMicrosoftExcel
Please rename the file Excel16.xlb to Excel16.xlb.old then reopen Excel and check the result.
answered Jan 8 at 1:40
Lee
86427
Excel15.xlb is probably irrelevant, since Excel 2016 is Excel16.
– Jon Peltier
Jan 15 at 3:08
OH,YES~My mistake.
– Lee
Jan 15 at 6:02
add a comment |
Please check if you add more commands to the Insert tab, try to remove them.
Then try to reset Ribbon option in Excel, please go to this path:
C:UsersUser NameAppDataRoamingMicrosoftExcel
Please rename the file Excel16.xlb to Excel16.xlb.old then reopen Excel and check the result.
answered Jan 8 at 1:40
Lee
86427
Excel15.xlb is probably irrelevant, since Excel 2016 is Excel16.
– Jon Peltier
Jan 15 at 3:08
OH,YES~My mistake.
– Lee
Jan 15 at 6:02
add a comment |
Please check if you add more commands to the Insert tab, try to remove them.
Then try to reset Ribbon option in Excel, please go to this path:
C:UsersUser NameAppDataRoamingMicrosoftExcel
Please rename the file Excel16.xlb to Excel16.xlb.old then reopen Excel and check the result.
answered Jan 8 at 1:40
Lee
86427
Please check if you add more commands to the Insert tab, try to remove them.
Then try to reset Ribbon option in Excel, please go to this path:
C:UsersUser NameAppDataRoamingMicrosoftExcel
Please rename the file Excel16.xlb to Excel16.xlb.old then reopen Excel and check the result.
answered Jan 8 at 1:40
Lee
86427
edited Jan 15 at 6:02
answered Jan 8 at 1:40
Lee
86427
answered Jan 8 at 1:40
Lee
86427
answered Jan 8 at 1:40
Lee
86427
86427
Excel15.xlb is probably irrelevant, since Excel 2016 is Excel16.
– Jon Peltier
Jan 15 at 3:08
OH,YES~My mistake.
– Lee
Jan 15 at 6:02
add a comment |
Excel15.xlb is probably irrelevant, since Excel 2016 is Excel16.
– Jon Peltier
Jan 15 at 3:08
OH,YES~My mistake.
– Lee
Jan 15 at 6:02
Excel15.xlb is probably irrelevant, since Excel 2016 is Excel16.
– Jon Peltier
Jan 15 at 3:08
Excel15.xlb is probably irrelevant, since Excel 2016 is Excel16.
– Jon Peltier
Jan 15 at 3:08
OH,YES~My mistake.
– Lee
Jan 15 at 6:02
OH,YES~My mistake.
– Lee
Jan 15 at 6:02
add a comment |
Make sure you haven't opened a sheet in compatibility view. If you have, go to the file menu and click convert. This will give you back these charts on this sheet
answered May 15 at 0:30
Dub Ambman
1
add a comment |
Make sure you haven't opened a sheet in compatibility view. If you have, go to the file menu and click convert. This will give you back these charts on this sheet
answered May 15 at 0:30
Dub Ambman
1
add a comment |
Make sure you haven't opened a sheet in compatibility view. If you have, go to the file menu and click convert. This will give you back these charts on this sheet
answered May 15 at 0:30
Dub Ambman
1
Make sure you haven't opened a sheet in compatibility view. If you have, go to the file menu and click convert. This will give you back these charts on this sheet
answered May 15 at 0:30
Dub Ambman
1
answered May 15 at 0:30
Dub Ambman
1
answered May 15 at 0:30
Dub Ambman
1
answered May 15 at 0:30
Dub Ambman
1
1
add a comment |
add a comment |
You need to get rid of compatibility view. Save as the file and reopen the new file. Should work now.
answered Jun 12 at 6:25
cryinginclass
1
add a comment |
You need to get rid of compatibility view. Save as the file and reopen the new file. Should work now.
answered Jun 12 at 6:25
cryinginclass
1
add a comment |
You need to get rid of compatibility view. Save as the file and reopen the new file. Should work now.
answered Jun 12 at 6:25
cryinginclass
1
You need to get rid of compatibility view. Save as the file and reopen the new file. Should work now.
answered Jun 12 at 6:25
cryinginclass
1
answered Jun 12 at 6:25
cryinginclass
1
answered Jun 12 at 6:25
cryinginclass
1
answered Jun 12 at 6:25
cryinginclass
1
1
add a comment |
add a comment |
Select "File", "Save As" and save the file as Excel Workbook (.xlsx) or some other recent versioning. If the workbook is saved as an older version of Excel, i.e. Excel 97-2003 (.xls), the Analysis Toolpak add-in will not work.
answered Jul 3 at 19:23
EByrd
1
add a comment |
Select "File", "Save As" and save the file as Excel Workbook (.xlsx) or some other recent versioning. If the workbook is saved as an older version of Excel, i.e. Excel 97-2003 (.xls), the Analysis Toolpak add-in will not work.
answered Jul 3 at 19:23
EByrd
1
add a comment |
Select "File", "Save As" and save the file as Excel Workbook (.xlsx) or some other recent versioning. If the workbook is saved as an older version of Excel, i.e. Excel 97-2003 (.xls), the Analysis Toolpak add-in will not work.
answered Jul 3 at 19:23
EByrd
1
Select "File", "Save As" and save the file as Excel Workbook (.xlsx) or some other recent versioning. If the workbook is saved as an older version of Excel, i.e. Excel 97-2003 (.xls), the Analysis Toolpak add-in will not work.
answered Jul 3 at 19:23
EByrd
1
answered Jul 3 at 19:23
EByrd
1
answered Jul 3 at 19:23
EByrd
1
answered Jul 3 at 19:23
EByrd
1
1
add a comment |
add a comment |
I solved the same problem just now: The file was saved as .xls and not .xlsx, so excel 2016 features did not apply for that file and automatically these features are disabled.
BTW, in my case it was noted as "Compitability mode" at the top of the screen.
So:
1. Save the file as .xlsx
2. Close it.
3. Open the .xlsx file
And voila statistical charts are there again.
answered Dec 13 at 10:21
Alon
1
2
Welcome to Super User, and kudos for solving your problem. However, EByrd posted this solution some months ago. The intention is that each answer should provide a solution that hasn't already been contributed.
– fixer1234
Dec 13 at 10:34
add a comment |
I solved the same problem just now: The file was saved as .xls and not .xlsx, so excel 2016 features did not apply for that file and automatically these features are disabled.
BTW, in my case it was noted as "Compitability mode" at the top of the screen.
So:
1. Save the file as .xlsx
2. Close it.
3. Open the .xlsx file
And voila statistical charts are there again.
answered Dec 13 at 10:21
Alon
1
2
Welcome to Super User, and kudos for solving your problem. However, EByrd posted this solution some months ago. The intention is that each answer should provide a solution that hasn't already been contributed.
– fixer1234
Dec 13 at 10:34
add a comment |
I solved the same problem just now: The file was saved as .xls and not .xlsx, so excel 2016 features did not apply for that file and automatically these features are disabled.
BTW, in my case it was noted as "Compitability mode" at the top of the screen.
So:
1. Save the file as .xlsx
2. Close it.
3. Open the .xlsx file
And voila statistical charts are there again.
answered Dec 13 at 10:21
Alon
1
I solved the same problem just now: The file was saved as .xls and not .xlsx, so excel 2016 features did not apply for that file and automatically these features are disabled.
BTW, in my case it was noted as "Compitability mode" at the top of the screen.
So:
1. Save the file as .xlsx
2. Close it.
3. Open the .xlsx file
And voila statistical charts are there again.
answered Dec 13 at 10:21
Alon
1
answered Dec 13 at 10:21
Alon
1
answered Dec 13 at 10:21
Alon
1
answered Dec 13 at 10:21
Alon
1
1
2
Welcome to Super User, and kudos for solving your problem. However, EByrd posted this solution some months ago. The intention is that each answer should provide a solution that hasn't already been contributed.
– fixer1234
Dec 13 at 10:34
add a comment |
2
Welcome to Super User, and kudos for solving your problem. However, EByrd posted this solution some months ago. The intention is that each answer should provide a solution that hasn't already been contributed.
– fixer1234
Dec 13 at 10:34
2
2
Welcome to Super User, and kudos for solving your problem. However, EByrd posted this solution some months ago. The intention is that each answer should provide a solution that hasn't already been contributed.
– fixer1234
Dec 13 at 10:34
Welcome to Super User, and kudos for solving your problem. However, EByrd posted this solution some months ago. The intention is that each answer should provide a solution that hasn't already been contributed.
– fixer1234
Dec 13 at 10:34
add a comment |
- had the exact same problem, I changed the compatibility view and it fixed everything. If you go to the file menu and click convert this will give you back the charts you are missing.
*
answered Jun 23 at 5:17
num
1
add a comment |
- had the exact same problem, I changed the compatibility view and it fixed everything. If you go to the file menu and click convert this will give you back the charts you are missing.
*
answered Jun 23 at 5:17
num
1
add a comment |
- had the exact same problem, I changed the compatibility view and it fixed everything. If you go to the file menu and click convert this will give you back the charts you are missing.
*
answered Jun 23 at 5:17
num
1
- had the exact same problem, I changed the compatibility view and it fixed everything. If you go to the file menu and click convert this will give you back the charts you are missing.
*
answered Jun 23 at 5:17
num
1
answered Jun 23 at 5:17
num
1
answered Jun 23 at 5:17
num
1
answered Jun 23 at 5:17
num
1
1
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.
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%2f1283122%2fchart-options-missing-in-excel-2016%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
It might be that some options are hidden because of limited space. Try dragging the vertical line (to the right of Pivot Chart) to the right, and maybe the missing options will appear.
– Bandersnatch
Jan 6 at 16:44
The line cannot be dragged. Maximizing the window doesn't help either.
– user4757174
Jan 6 at 16:46
Can you find Histograms under Recommended Charts>All Charts? This will tell you if you're missing the charts entirely, or just a ribbon shortcut to them.
– dav
Jan 8 at 13:05
For some reason, you're missing all of the new chart types. Treemap, Sunburst, Histogram, Pareto, Boxplot, Waterfall. What specific version of Excel? Under the red Office logo in File > Account, it says Microsoft Office [Something Something] 2016: what's in brackets? Also, below that it says version something and build something: what are these numbers? And what version of Windows?
– Jon Peltier
Jan 13 at 3:24