Step 9: Add the cut off line by double clicking on the chart and under click “Chart Tools” on and Click on under the side of the pop up box “Select Data” “Add” “Legend Entries” and under highlight cells E9 through E16 and then click on and in “Series Values” “OK” the Data box click on and again. “Select Source” “OK” “OK” Step 10: Format the cutoff line. Right click on the line you just created and select Data and “Format Series” under select select and “Marker Options” “None”. Under “Line Color” “Solid Line” change the color to under change the width to 2pt. “Black”. Lastly, “Line Style” and change the to “Dash Type” “Round Dot”. Your graph should now look like this. Step 11: Highlight 80% of errors. Change the color of the bars to grey for the categories Wrong Size to Other which will help to highlight the 3 error types that account for 80% of the errors. Double click on the graph and then double click on the bar for and “Wrong Size” click on the bar one more time to highlight only that bar now right click and select Data and under select and change the color to “Format Point” “Fill” ‘Solid Fill” grey. Follow these steps to change the bar color for the remaining bars. Now your chart should look like this. Step 12: Final touches. We like to keep things as simple as possible, so we want to simplify the line by eliminating the boxes on it.
Step 9: Add the cut off line by double clicking on the chart and under “Chart Tools” click on “Select Data” and Click on “Add” under the “Legend Entries” side of the pop up box and under “Series Values” highlight cells E9 through E16 and then click on “OK” and in the “Select Data Source” box click on “OK” and “OK” again. Step 10: Format the cutoff line. Right click on the line you just created and select “Format Data Series” and under “Marker Options” select “None”. Under “Line Color” select “Solid Line” and change the color to “Black”. Lastly, under “Line Style” change the width to 2pt. and change the “Dash Type” to “Round Dot”. Your graph should now look like this. Step 11: Highlight 80% of errors. Change the color of the bars to grey for the categories Wrong Size to Other which will help to highlight the 3 error types that account for 80% of the errors. Double click on the graph and then double click on the bar for “Wrong Size” and click on the bar one more time to highlight only that bar now right click and select “Format Data Point” and under “Fill” select ‘Solid Fill” and change the color to grey. Follow these steps to change the bar color for the remaining bars. Now your chart should look like this. Step 12: Final touches. We like to keep things as simple as possible, so we want to simplify the line by eliminating the boxes on it.