Hello, I am trying to make a histogram on excel from frequency distribution. My bin numbers are 0, 500, 1000, 1500, 2000, 2500, and 3000 and the corresponding frequencies are 4, 7, 15, 22, 11, and 1. I have already tried selecting the data analysis tool and clicking on the histogram option but a graph never showed up, and instead the chart I highlighted in gray pops up. How can I fix this?

GB215project - Excel (Product Activation Failed) Home Insert Page Layout Formulas Data Review View Developer Tell me what you want to do. Gangi, Taylor A1 X V fx A B C D F G H K L M N O P Q 1| Balance 10 00 V O UT A W N 2557 Highest 2557 Groups Frequency count Bin # 2409 Lowest 32 1-500 500 2375 Range 2525 501-1000 1000 2276 Width of interval 505 1001-1500 1500 2215 1501-2000 2000 2204; 2001-2500 2500 2156 2501-3000 3000 2144 10 2138 11 2125 12 2076 Histogram ? X 13 2051 Bin # Frequency Input 14 1995 OK 500 4 Input Range: $A$1:$A$61 15 1989 1000 7 Cance 16 1958 1500 15 Bin Range: $K$2:$K$8 17 1913 2000 22 Labels Help 18 1886 2500 11 500 19 1885 3000 1 1000 Output options 20 1838! More 0 1500 15 Output Range: $D$24 21 1831 2000 22 New Worksheet Ply: 22 1790 2500 11 New Workbook 23 1784 3000 1 24 1756! More ol Pareto (sorted histogram) 25 1746! Cumulative Percentage 26 1735 Chart Output Sheet1 + 4 Point Average: 812.3076923 Count: 14 Sum: 10560 HOW -- -+ 100% Type here to search O W P3 e Fz 1:40 PM ~ * 4/24/2020 X Home End Insert F5 F6 F7 E8 F9 F10 F11 F12 S 4 5