excel: horizontal single row high low close chart

I am using MS excel 2013.

I am trying to create a small single line chart to be included in a report. I would like a horizontal line representing a range of the lowest and highest figures from the last twelves months, with a point on that line representing the current position of the figure. I would also like this chart to always be the same length. I would imagine this part is easy though as I would calculate percentages, then use them to drive the chart.

something like this: example of a chart I am trying to create

The 'stock' 'high-low-close' chart allows me to achieve this for multiple data points. But not for a single row of data.

Here's an example of a 'stock' 'high-low-close chart': this is the closest I have got

Recent Questions...