How to make histogram using a result set containing a integer and a varchar

I have made an sql query that ends up with the following format :

ID      Occurrences
Monday    5455
Tuesday   4454 
Wednesday 4433
Thursday  3343
Friday    3433
Saturday  2342
Sunday    8888

How do I present this in a nice histogram in Grafana?

I have tried to make this happen with the Graph panel, on the Axis tab, in the X-Axis Mode section I have selected Series, but the histogram does not appear. Neither the Histogram option in Mode makes the job.

Could you please assist?