How to make a histogram on excel 2010?

%3CLINGO-SUB%20id%3D%22lingo-sub-1884573%22%20slang%3D%22en-US%22%3EHow%20to%20make%20a%20histogram%20on%20excel%202010%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1884573%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20excel%202010%20and%20I%20need%20to%20make%20a%20histogram%2C%20I%20have%20been%20googling%20endlessly%20on%20how%20to%20do%20so%20as%20it%20should%20be%20simple%2C%20but%20I%20need%20to%20apparently%20have%20add-in's%20toolpak%3F%20I%20have%20tried%20but%20I%20literally%20do%20not%20have%20any%20of%20those%20options.%20I%20go%20to%20'file'%20i%20have%20no%20'options'%20bar%2C%20but%20apparently%20that%20is%20not%20for%20mac.%20I%20have%20a%20mac%20and%20so%20I%20followed%20what%20was%20said%20to%20be%20done%20for%20a%20mac%20but%20I%20still%20do%20not%20have%20the%20options%20available.%20I%20went%20to%20'tool's%20and%20'add%20in's'%20but%20when%20I%20click%20on%20that%20I%20have%20a%20single%20option%20available%20nothing%20to%20do%20with%20a%20toolpak.%20Please%20could%20someone%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1884573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1884860%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20make%20a%20histogram%20on%20excel%202010%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1884860%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F868121%22%20target%3D%22_blank%22%3E%40HaafsahB330%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EA%20histogram%20is%20a%20graphic%20representation%20of%20the%20frequency%20distribution%20of%20cardinally%20scaled%20features.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt%20requires%20the%20data%20to%20be%20divided%20into%20classes%20(bins)%2C%20which%20can%20have%20a%20constant%20or%20variable%20width.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESource%3A%20Wikipedia%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHistogram%20in%20Excel%20-%20Infos%20%26amp%3B%20Steps%3A%3C%2FP%3E%3CP%3ECreate%20a%20histogram%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-histogram-85680173-064b-4024-b39d-80f17ff2f4e8%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-histogram-85680173-064b-4024-b39d-80f17ff2f4e8%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3ETo%20create%20a%20histogram%20in%20Excel%202011%20for%20Mac%2C%20you'll%20need%20to%20download%20a%20third-party%20add-in.%20See%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fload-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EI%20can't%20find%20the%20Analysis%20Toolpak%20in%20Excel%202011%20for%20Mac%3C%2FA%3E%20for%20more%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I have excel 2010 and I need to make a histogram, I have been googling endlessly on how to do so as it should be simple, but I need to apparently have add-in's toolpak? I have tried but I literally do not have any of those options. I go to 'file' i have no 'options' bar, but apparently that is not for mac. I have a mac and so I followed what was said to be done for a mac but I still do not have the options available. I went to 'tool's and 'add in's' but when I click on that I have a single option available nothing to do with a toolpak. Please could someone help me.

1 Reply
Highlighted

@HaafsahB330 

A histogram is a graphic representation of the frequency distribution of cardinally scaled features. It requires the data to be divided into classes (bins), which can have a constant or variable width.

Source: Wikipedia

 

Histogramm in Excel - Infos & Steps:

Create a histogram

https://support.microsoft.com/en-us/office/create-a-histogram-85680173-064b-4024-b39d-80f17ff2f4e8?u...

To create a histogram in Excel 2011 for Mac, you'll need to download a third-party add-in. See: I can't find the Analysis Toolpak in Excel 2011 for Mac for more details.

 

Hope I was able to help you.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here