Bullet Diagram Labeled. The complicated part is the actual gun right. Next click the data label right click and format data labels.
Follow the steps below to learn how to create a bullet graph. Below is a single bullet graph showing how actual sales compared to estimated sales. There are so many different bullet calibers sizes and types that it can really make your head spin so to try and help those.
You ll see examples of different bullets used throughout the rest of this article.
Usually we want our bullets to automatically be colored the same as the series. The complicated part is the actual gun right. At this point you can set it to be a percent currency or whatever format you want. Click on the chart series that contains the bullet right click on it and then choose add data labels.