Excel 2013 histogram making tutorial:
Histogram making Step 1: As shown in the figure, select the data area--click Insert--Recommended chart--Clustered Column chart.
Histogram making Step 2: By adjusting the clustered column chart into a histogram.
Histogram making Step 3: As shown, double click (column)--go to set data point format--series options--category spacing (adjust to 0)
Histogram making step 4: As shown, click the Chart tool-format-vertical (value) axis--Set the selection format, for histogram beautification.
Histogram making Step 5: mainly includes the following four aspects: 1. Vertical (value) axis, 2. Vertical (value) axis major gridlines, 3. Horizontal (category) axis, 4. Add Data labels
Histogram making Step 6: Vertical (value) axis
Histogram make Step 7: Click Format Axis--Set color--set width--Add arrowhead end type.
Histogram making Step 8: Vertical (value) axis main grid line
Histogram make step 9: Format main gridlines--color--dash type.
Histogram making step 10: Horizontal (category) axis
Histogram make step 11: Set the axis format--color--width--arrowhead end type.
Histogram make step 12: Set the axis format-tick mark--main type (internal).
Histogram making step 13: Adding data labels
Histogram make step 14: Right click--Add Data label.
Histogram making step 15: Finally, do other processing