Bins For Histogram Excel How To Format Your

Cookie-instellingen OK 10006 Categorien Computers Elektronica Software Een histogram in Excel maken.

Jack Lloyd is technologieschrijver en -redacteur voor wikiHow.

Hij heeft twee jaar ervaring met het schrijven en bewerken van artikelen over technologische onderwerpen.

Als deze optie niet in het gegevensmenu aanwezig is, dan kan het zijn dat je een invoegtoepassing moet installeren.

Dit doe je door naar Bestand Opties Invoegtoepassingen te gaan.

Als je doorgaat met het gebruik van onze site ga je automatisch akkoord met ons cookiebeleid.

Earlier versions of Office (Excel 2013 and earlier) lack this feature.

You might, for instance, be looking to take a set of student test results and determine how often those results occur, or how often results fall into certain grade boundaries.

You can select the data manually, or by selecting a cell within your range and pressing CtrlA on your keyboard.

The various chart options available to you will be listed under the Charts section in the middle.

Bins For Histogram Excel How To Format Your

Excel will attempt to determine how to format your chart automatically, but you might need to make changes manually after the chart is inserted.

For instance, for a list of student test results out of 100, you might prefer to group the results into grade boundaries that appear in groups of 10.

If you want to change these settings, however, switch to another option.

For a list of student test results, this would separate each result by student, which wouldnt be as useful for this kind of analysis.

Setting 10 bins here, for instance, would also group results into groups of 10.

The highest number in that range is 34, so the axis label for that bin is displayed as 27, 34.

This ensures as equal distribution of bin groupings as possible.

If you want to ensure that a set number of bin groupings are always displayed, however, this is the option youd need to use.

For instance, if you wanted to carefully analyze data under or above a certain number, you could tick to enable the Overflow Bin option and set a figure accordingly.

Bin ranges below 50 would still be displayed, but data over 50 would be grouped in the appropriate overflow bin instead.

Other bin groupings would display as normal, but data below 50 would be grouped in the appropriate underflow bin section.

Further changes to the text and bar colors and options can be made by right-clicking the chart itself and selecting the Format Chart Area option.