Tip: Create a Pareto chart in Excel by first creating a column chart with your data. Then, add a secondary axis and create a line chart that displays the cumulative percentage.