How to make this one dimensional chart?

[locolindo]

Hi there,
I want to be able to create a one-dimensional chart like the one in the attachment submitted. Please note that the scale is a little weird. I would like to input a score and have the bar move accordingly, as seen in the attachment.

https://drive.google.com/file/d/0B0Ot1j4sbShoMFhBcFFpWFpnbFU/view?usp=sharing


Best,
Locolindo

 

[thisoldman]

That looks like a bullet chart sized to cover three cells. Tutorials are available at:
http://peltiertech.com/bullet-charts-in-excel/
http://www.exceluser.com/excel_dashboards/bullet-graph.htm
and
http://www.excelcharts.com/blog/how-make-bullet-charts-excel/

 

[locolindo]

Thanks thisoldman!!! This was very helpful. I ended up doing a bullet chart and used a vlookup table to account for the funny scale...
thanks again!