Excel 2013 histogram How to make

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