Seems like you have very old data, decades ago for example. Please make sure to change the time range in the upper right corner of the dashboard so that it include data within certain hire_date.
I’m not sure exactly how you want to track hires over time, but I’m guessing that hires/gender/month could be interesting. In that case I would suggest that you use the X-Axes Mode Time instead and a query similar to the following. Please note that you’ll need Grafana nightly build / v5.0 beta for the $__timeGroup to be supported with MySQL.
$__timeGroup(hire_date,'720h') as time_sec,
count(emp_no) as value,
gender as metric
GROUP BY 1, 3
ORDER BY 1
Then you could change some panel settings. Display tab -> Draw mode -> Bars and Stack checked. You can now change time range to a year where you have data in your table and it should render a stacked bar (M/F) per each month (30 days).
What I suggested would look similar to this graph: http://play.grafana.org/d/000000016/graph-styles?panelId=13&fullscreen&edit&orgId=1
What you tried to achieve earlier was similar to this graph: http://play.grafana.org/d/000000016/graph-styles?panelId=19&fullscreen&edit&orgId=1
If you still want to use the X-Axes mode series you’ll need to rewrite your query so that the value of metric will be your buckets you want to display as bars, for example year or month of hire_date.