Forum Discussion
The Histogram does not exist in my excel on the Insert then chart, recommended chart
- Mira S. on the Excel community board figured it out in 2019. I just stumbled upon her post. Amen. I tried it out and it works. just re-save the .xls under the proper/updated version with the .xlsl
Sep 11 2019 06:29 PM
Office 365 Excel Histogram
I just installed Office 365. I need to create a histogram chart for a class assignment. I did the add-in for the Analysis ToolPac. I don't have histogram chart available on my insert ribbon. I rebooted my computer, still no histogram chart option. I ran the office updater, updates are up to date. I again rebooted my computer. Still no Histogram on the Insert Ribbon. How do I get more available charts under the Insert ribbon? On the professor's youtube video, his excel has 8 different options for charts under the insert tab. Can anyone instruct me on how to add this button to the charts tab under insert? Any help appreciated.
Labels: Charting Excel Office 365
Sep 11 2019 06:56 PM - edited Sep 11 2019 06:57 PM
Mira_S The file you attached is an old format .xls file. This file format was used in Excel up to version 2003.
When this file is opened with modern Excel, it will be in "compatibility mode" and any features that were added to Excel in versions 2007 and up will not be available.You need to use the Save As command and then select Excel Workbook (*xlsx) in the drop down for the file type, where it currently says Excel 97-2003 Workbook (*.xls)
Re: Office 365 Excel Histogram
After that, you need to close the workbook and open it again. Check the green title bar at the top of the Excel window. If it says "Compatibility mode" it still runs in the old Excel mode.
Carie
I'm in Europe, 6 hours ahead of you. It's currently 15:15 (3:15 PM)
- Mira S. on the Excel community board figured it out in 2019. I just stumbled upon her post. Amen. I tried it out and it works. just re-save the .xls under the proper/updated version with the .xlsl
Sep 11 2019 06:29 PM
Office 365 Excel Histogram
I just installed Office 365. I need to create a histogram chart for a class assignment. I did the add-in for the Analysis ToolPac. I don't have histogram chart available on my insert ribbon. I rebooted my computer, still no histogram chart option. I ran the office updater, updates are up to date. I again rebooted my computer. Still no Histogram on the Insert Ribbon. How do I get more available charts under the Insert ribbon? On the professor's youtube video, his excel has 8 different options for charts under the insert tab. Can anyone instruct me on how to add this button to the charts tab under insert? Any help appreciated.
Labels: Charting Excel Office 365
Sep 11 2019 06:56 PM - edited Sep 11 2019 06:57 PM
Mira_S The file you attached is an old format .xls file. This file format was used in Excel up to version 2003.
When this file is opened with modern Excel, it will be in "compatibility mode" and any features that were added to Excel in versions 2007 and up will not be available.You need to use the Save As command and then select Excel Workbook (*xlsx) in the drop down for the file type, where it currently says Excel 97-2003 Workbook (*.xls)
Re: Office 365 Excel Histogram
After that, you need to close the workbook and open it again. Check the green title bar at the top of the Excel window. If it says "Compatibility mode" it still runs in the old Excel mode. - It sounds like that software must emulate Excel in a controlled environment. In doing so, it may run it in compatibility mode. Glad you found a solution!
- Let me re-write that last part.
I opened Excel, opened a blank spreadsheet, entered a few numbers, selected the cells and the ability to select statistical charts is there. It is something within the Achieve program. I am thinking the Professor knows about it. Why he did not tell me... grrrr..
Thank you. Patrick2788 I click on a link that is in a software program that the Professor has chosen, it is a self-learning program for an online course in statistics. The program/software is called Achieve.
Across the top of the Excel data, which is already put into the spreadsheet by the Achieve program so that we at least don't have to enter it, for each homework and exam question.
The name of the File/Document -- Protected View -- Saved to this PC \/ That arrow at the end, I drew -- is smaller at the top left of the spreadsheet at the very top of my screen.
I just entered some data into a column, selected the data, clicked on chart and all of the statistical charts/graphs, etc. are there - it has to do with the Achieve software.
Wow, thank you! I was on with MicroSoft Tech support for just over two hours this morning - we both missed it.
Phew - now to email the professor.
- Do you happen to be working in Compatability Mode/working with an .xls file?
- No, did not fix it. I'll have to use the online Excel. Thanks for your help.
Ugh. HansVogelaar What a waste of a day. Chatting with MS Tech support to figure out why the statistical graphs/charts are not under insert.
I have to use the online verson of excel. over 2 hours and we couldn't figure it out.
I did mention that my professor had us add Data analysis onto the toolbar at the very end - and that I will try and undo it. I think that eliminated it from the Insert, Chart toolbar.
I'm going to give that a try right now. I'll use the online version for now, but it will bug me until I give it a try. Ah yes 6 hours ahead.
I'll let you know if this works.
Carie
