How to Add Levels to a QI Macros Bullet Chart

Step by Step Example of Adding a 4th Level

1. Insert data for the new level:



2. Copy/Paste new data into your Bullet Chart (copy cells, click on the chart and paste - Ctrl + V) :



3. Change Series Chart Type to "Clustered Bar (horizontal bullet) or Clustered Column (vertifical bullet) :





4. Next, right-click on the new Bar and Change Colors:



5. Then, right-click on the chart, click "Select Data", and move up to correct place:





6. Right-click on the new bar and select "Format Data Series":



7. Lastly, the change "Series Overlap" to 100% and "Gap" to 50%

The Bullet Chart is one of many charts and tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find and open any chart template you need.

Other Charts Included in QI Macros Add-in for Excel

Control Charts

Histograms

Pareto Charts

Box Plots

Fishbone Diagram