To configure Pareto chart data columns

  1. If you have not already done so, insert a Pareto chart by selecting it from the Insert menu, or double-click an existing chart to access the configuration panel.

  2. Select the Data tab.

  3. From the Frequency Column list box, select the data column that you want to be used as the frequency on the chart.

  4. If you want a specific number of categories (bars), select the Show Fixed Number of Categories check box and enter the number of categories (any number).

  5. To group the remaining category values in one extra bar, select the Show Bar of Remaining Categories check box.

  6. To change the width of the cumulative percentage line, select a value from the Line Width list box.

  7. To change the line style of the cumulative percentage line, select an option from the Line Style list box.

  8. To add more space between the bars, select a value from the Inter-Bar Gap list box. The larger the number, the greater the gap is between the bars.