W
Workbook
I got this link http://www.exceluser.com/explore/bullet.htm
From Smartin. It’s a great link about how to create bullet charts. The
question I have is related to this link. If you follow the instructions it
works great. However I am trying to modify the bullet chart so that it can
communicate progress in hours and minutes. As a result I think where I am
having the challenge is related to the The Value Y Axis. I tried changing
the number tab category to selection custom/mm:ss, however after I click OK
the Bullet Chart displays 00:00 all the way down instead of times like 5 min,
10 min etc. The range I am looking to use is between 0 min and 30 min with 5
min intervals. Any thoughts?
From Smartin. It’s a great link about how to create bullet charts. The
question I have is related to this link. If you follow the instructions it
works great. However I am trying to modify the bullet chart so that it can
communicate progress in hours and minutes. As a result I think where I am
having the challenge is related to the The Value Y Axis. I tried changing
the number tab category to selection custom/mm:ss, however after I click OK
the Bullet Chart displays 00:00 all the way down instead of times like 5 min,
10 min etc. The range I am looking to use is between 0 min and 30 min with 5
min intervals. Any thoughts?