SOLVED
Home

Office 365 Excel Histogram

%3CLINGO-SUB%20id%3D%22lingo-sub-850149%22%20slang%3D%22en-US%22%3EOffice%20365%20Excel%20Histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-850149%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20installed%20Office%20365.%20I%20need%20to%20create%20a%20histogram%20chart%20for%20a%20class%20assignment.%20I%20did%20the%20add-in%20for%20the%20Analysis%20ToolPac.%20I%20don't%20have%20histogram%20chart%20available%20on%20my%20insert%20ribbon.%20I%20rebooted%20my%20computer%2C%20still%20no%20histogram%20chart%20option.%20I%20ran%20the%20office%20updater%2C%20updates%20are%20up%20to%20date.%20I%20again%20rebooted%20my%20computer.%20Still%20no%20Histogram%20on%20the%20Insert%20Ribbon.%20How%20do%20I%20get%20more%20available%20charts%20under%20the%20Insert%20ribbon%3F%20On%20the%20professor's%20youtube%20video%2C%20his%20excel%20has%208%20different%20options%20for%20charts%20under%20the%20insert%20tab.%20Can%20anyone%20instruct%20me%20on%20how%20to%20add%20this%20button%20to%20the%20charts%20tab%20under%20insert%3F%20Any%20help%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-850149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-850172%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%20Histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-850172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F407600%22%20target%3D%22_blank%22%3E%40Mira_S%3C%2FA%3E%26nbsp%3BThe%20file%20you%20attached%20is%20an%20old%20format%20.xls%20file.%20This%20file%20format%20was%20used%20in%20Excel%20up%20to%20version%202003.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20this%20file%20is%20opened%20with%20modern%20Excel%2C%20it%20will%20be%20in%20%22compatibility%20mode%22%20and%20any%20features%20that%20were%20added%20to%20Excel%20in%20versions%202007%20and%20up%20will%20not%20be%20available.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20to%20use%20the%20Save%20As%20command%20and%20then%20select%26nbsp%3B%3CSTRONG%3EExcel%20Workbook%20(*xlsx)%3C%2FSTRONG%3Ein%20the%20drop%20down%20for%20the%20file%20type%2C%20where%20it%20currently%20says%20Excel%2097-2003%20Workbook%20(*.xls)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20325px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131385i4E9AE3F11739B61B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-12_13-53-03.png%22%20title%3D%222019-09-12_13-53-03.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20that%2C%20you%20need%20to%26nbsp%3B%3CSTRONG%3Eclose%20the%20workbook%26nbsp%3B%3C%2FSTRONG%3Eand%20open%20it%20again.%20Check%20the%20green%20title%20bar%20at%20the%20top%20of%20the%20Excel%20window.%20If%20it%20says%20%22Compatibility%20mode%22%20it%20still%20runs%20in%20the%20old%20Excel%20mode.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-850340%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%20Histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-850340%22%20slang%3D%22en-US%22%3ESometimes%20you%20can't%20see%20the%20trees%20because%20you've%20been%20banging%20your%20head%20on%20it%20for%20so%20long.%20Thank%20You%20Ingeborg%20Hawighorst.%20Your%20instructions%20worked%20perfectly.%3C%2FLINGO-BODY%3E
Mira_S
New Contributor

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.

2 Replies
Solution

@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)

 

2019-09-12_13-53-03.png

 

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.

 

Sometimes you can't see the trees because you've been banging your head on it for so long. Thank You Ingeborg Hawighorst. Your instructions worked perfectly.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies