To create a frequency chart for lottery numbers, you can use the following steps:

1. Select the range of cells that contain the lottery numbers (
   Code:

   A1:E100

   in your case).
2. Go to the "Formulas" tab in the Excel ribbon and click on "More Functions" "Statistical" "FREQUENCY".
3. In the "Data Array" field, select the range of cells that contain the lottery numbers.
4. In the "Bins Array" field, select the range of cells that contain the numbers 1 through 59 (
   Code:

   K1:K59

   in your case).
5. Press "Ctrl + Shift + Enter" to enter the formula as an array formula. This will calculate the frequency of each number in the lottery numbers range.
6. To view the resulting array of frequencies, select a range of cells that is the same size as the "Bins Array" range (
   Code:

   K1:K59

   in your case).
7. Type the formula "
   Code:

   =FREQUENCY(A1:E100,K1:K59)

   " into the formula bar and press "Ctrl + Shift + Enter". This will populate the selected range with the frequency values.
8. To create a histogram, select the range of cells that contain the frequency values and the range of cells that contain the numbers 1 through 59 (
   Code:

   K1:K59

   in your case).
9. Go to the "Insert" tab in the Excel ribbon and click on "Recommended Charts". Select the "Histogram" chart type and choose the chart style that you prefer.

And that's it! You should now have a frequency chart that shows the frequency of each number in the lottery numbers range. Good luck with your lottery winnings!