![]() ![]() 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. The histogram is divided into “bins,” which represent age ranges in our example. 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. 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. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |