Excel 2013, How do I make a histogram like this in excel 2013?

Q&A DQ Courses
,
#1

How do I, make a histogram like this in excel 2013?

image
image1600×900 126 KB

I keep getting this when I try and the pattern is really different

The question is from this course Learn data science with Python and R projects

image
image1600×900 106 KB

#2

Hi @OlutokiJohn

  1. Select the column or range of values.
  2. Click the INSERT menu (in the ribbon). You should be able to see chart options.
  3. Select Histogram from charts/ Other charts section.

I am accessing excel online not the desktop version, so the image may look a bit different.

image
image774×667 40.2 KB

Thereafter, use format options to customize. like bin size, axis labels etc.

#3

Nothing like that on my screen.

image
image1600×900 74.3 KB

#4

Check under the recommended charts or this Pareto chart-like option highlighted.

image