Thread: Bullet Chart

I attached a workbook named Dashboard – Draft 20 with two sheets; they are called “Horizontal Bullet Charts” and “Vertical Bullet Chart”. I’ve been having a hard time trying to turn the vertical bullet chart horizontal without using edit paste picture link. Ideally I want to put one bullet chart in each of the green shaded areas on the sheet “Horizontal Bullet Charts”. If you could help I would appreciate it. Also, if it’s possible could you explain to me how you were able to turn it horizontal? Ultimately I want to create a dozen or more of the horizontal bullet charts in the workbook that I attached.

I have been using the instructions from this link...

http://www.exceluser.com/explore/bullet.htm

..but the suggestions for turning the chart horizontal don’t seem to be working for me, or maybe I am not doing it correctly.

Thanks for your input.