![]() ![]() ![]() ![]() It has started from 3 as that is the lowest age in the data table. You will now see the bins ranging from 3-13, 13-23, and so on. If you want Excel to dynamically calculate the bin width for you, you can set the number of bins instead.įor our example, we will change the age range to 10 years. A pane will appear on the right side.Īdjust the Bin width to change the age range covered by each column in the histogram. To change the age range, Right-click on the horizontal axis of the graph and select Format Axis. You can modify these bins to suit your preference.Įach column, or bin represent an age group in the guest list. For example, if you decided to use bins that increase by 10, you would type in 10 here. Excel will automatically format the histogram to display the appropriate number of columns based on your bin number. The histogram is divided into “bins,” which represent age ranges in our example. Type into the 'Bin width' text box the value of an individual bin number, then press Enter. To Resize the graph, click on one of the corner circles and adjust the borders of the graph area as needed.ĭouble-click on the Chart Title and enter a new name to change the title of the histogram. In the Select Data Source dialog box, select the Horizontal (Category) axis labels edit box, click and drag A2:A6, and click OK. To change the location of the histogram within your spreadsheet, Click on a blank space within the graph area, hold the Left Mouse button, and Drag the graph to the desired position. With the axis selected, choose Chart Design (ribbon) > Select Data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |