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.
To customize the histogram, you can make adjustments to its location, size, and title. In our case, we will Select our data table, which contains the ages of the 30 wedding guests.Įxcel will automatically generate the histogram in the spreadsheet area. For this example, let’s consider a dataset containing the ages of 30 people on a wedding guest list.īegin by Selecting the data range that you want to use for the histogram. To begin creating a histogram, it’s important to make sure your data is properly arranged in either a single column or row within an Excel worksheet.
