How to create bullet chart and horizontal bullet chart in Excel?

This method will introduce the tutorial to create a bullet chart in Excel. Please do as follows:

1. Select the table you will create a bullet chart based on, and click Insert > Insert Column or Bar Chart > Stacked Column. See screenshot:

2. Keep the new chart selected, and click Design (under Chart Tools) > Switch Row/Column. See screenshot:

3. Now simplify the new chart as you need. In my case, I remove the gridlines, horizontal axis, chart title, and narrow the chart area. See screenshot:

4. In the chart, right click the Target data series, and select Change Series Chart Type from the context menu. See screenshot:

5. In the Change Chart Type dialog, please change the chart type of Target to Stacked Line with Markers, enable corresponding Secondary Axis, and click the OK button. See screenshot:

6. Click to select the secondary axis in the chart, and press Delete key to remove it. See screenshot:

7. Now right click the blue point of the Target series in the chart, and select Format Data Series from the context menu. See screenshot:

8. In the Format Data Series pane, go to Fill & Line > Marker, and then:
(1) In the Marker Options section, check the Built-in option, select dashes from the Type drop-down list, and specify a suited size in the Size box (in my case I specify it as 18 according to t
he chart size);
(2) In the Fill section, specify a color from the Color drop-down list;
(3) In the Border section, check the No line option.

9. Go back to the chart, right click the Actual data series, and select Change Series Chart Type from the context menu. See screenshot:

10. In the Change Chart Type dialog, tick the Secondary Axis checkbox in the Actual row, and click the OK button. See screenshot:

11. In the chart, right click the Actual data series, and select Format Data Series from the context menu. See screenshot:

12. In the Format Data Series pane, please do as follows:
(1) Under the Series Options tab, specify a suited Gap Width based on your chart size;
(2) Under the Fill & Line tab, choose a color from the Color drop-down list.

13. Change the fill color for the Low, Medium, and High data series.
Take the Medium data series for example, right click the Medium data series in the chart, and select Format Data Point from the context menu.

In the Format Data Point pane, under the Fill & Line tab, choose a color from the Color drop down list. See screenshot:

And then change the fill color for the other data series with the same way.
So far, we have created a normal bullet chart in Excel. See screenshot:

In this part, I will introduce a trick to create a horizontal bullet chart based on an existing vertical bullet chart in Excel. Please do as follows:

1. Create a normal bullet chart in Excel.

2. Select the range containing the whole bullet chart, and press Ctrl + C keys together to copy it.

3. Select a blank cell, right click, and select Paste Special > Linked Picture from the context menu. See screenshot:

4. Keep the linked picture selected, and click Format (under Picture Tools) > Rotate > Rotate Right 90°. See screenshot:

5. Go to the original vertical bullet chart, right click the vertical axis, and select Format Axis from the context menu.

6. Then go to the Format Axis pane, please select Rotate all text 270° from the Text direction under the Size & Properties tab. See screenshot:

7. Select the linked picture, and click Format (under Picture Tools) > Crop, and then crop the linked picture as you need. See screenshot:

Up to now, we have got a horizontal bullet chart in Excel. See screenshot: