Create Histogram in Excel using time data

Question

I am trying to take the duration data from a webinar and display it graphically via a histogram or bar chart.  In cells G2:G11 tried using =frequency(d2:d319,f2:f11) but I keep getting all zeros.  I am using custom format h:mm:ss in both columns.  

Answer 1

I am trying to take the duration data from a webinar and display it graphically via a histogram or bar chart.  In cells G2:G11 tried using =frequency(d2:d319,f2:f11) but I keep getting all zeros.  I am using custom format h:mm:ss in both columns.  

1.

Highlight the range where you want your Bins for example:-

G2:G12

 - then enter:-

=FREQUENCY(D2:D319,F2:F11)

 - then hit:-

CTRL + SHIFT + ENTER

2.

Cells:-

G2:G12

 - should now be filled with the correct values.

3.

Adjust above ranges to suit your own.

4.

See screen shot below.

Answer 2

PS See here also:-

FREQUENCY function - Excel for Microsoft 365

 - where it states (in part):-

Note: If you have a current version of Microsoft 365, then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula.

Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, entering the formula in the top-left-cell of the output range, and then pressing CTRL+SHIFT+ENTER to confirm it.

Excel inserts curly brackets at the beginning and end of the formula for you. For more information on array formulas, see Guidelines and examples of array formulas.

Answer 3

Hi Brad Damman,

I go through your post carefully as per your description, in Excel you can also go to Data tab>Data Analysis command to create a Histogram to find the data frequency.

![](https://learn-attachment.microsoft.com/api/attachments/faeef4af-7571-4d1a-8034-acfb02ef9a2d?platform=QnA

Answer 4

Hi Brad Damman,

Feel free to post back if you need further assistance.

Best Regards,

Waqas Muhammad