Business Template - Bullet Chart

Standard Bullet Chart To use: 1 Copy the tan (orange) shaded area below including the bullet graph by going Ctrl-C. 2 Go to a blank area in your workbook. Go Ctrl-V. 3 Right-click on the chart and go to Source Data. Go To the Data Range Tab. 4 For each of the series, CAREFULLY change the worksheet from bullet.xls to the name of your workbook. The Source Data will still be pointing to the bullet.xls workbook. In the Source Data box, select the box of yellow cells below. 5 Edit the data in the blue cells to suit. Usually you want to link some or all of this to data in your worksheet. Change the format in the YELLOW cells to change the format on the axis 6 If you want to move the bullet chart to another sheet, use Cut (Ctrl-X) and paste (Ctrl-V) on the chart itself (tip: 7 Alter the colors and other characteristics by just right-clicking. Min 0.20 Value Min Mid Max Mid 0.25 Gradation 0.20 0.05 0.02 Value 0.23 Actual 0.23 0.02 0.02 Max 0.27 Gradations 0.20 0.05 0.02 Adapted from Charley Kyd and www.ExcelUser.com. 0.05 0.10 0.15 0.20 0.25of your workbook. data in your worksheet. Ctrl-V) on the chart itself (tip: use the arrow on the Drawing toolbar makes it easier). 0.30