Version

Working with Pareto Chart Data

This topic discusses useful information that will help you to ensure that your data is rendered properly in the pareto chart.

Data Requirements

While the Chart control allows you to easily point the chart to your own custom data, it is important that you are supplying the appropriate amount and type of data that the chart requires. If the data does not meet the minimum requirements based on the type of chart that you are using, an error will be generated.

The following is a list of data requirements for pareto charts:

Note
Note

If the data available is in a format where there is one numeric column and many rows, then you should swap the rows and columns. In this case, a value in a string column in each row will be used as the item label. For information on how to do this, see Swap Rows and Columns.

Mapping Data to Pareto Charts

The chart data is rendered using the following rules:

  • Only the first row of data will be plotted.

  • Column names will be used as item labels.

See below for an example data set, along with the rendered pareto chart.

Week# ActiveX Java NET

Week 1

25

85

65

Week 2

15

200

95

Week 3

100

45

110

Week 4

120

75

99

Week 5

60

113

50

Shows a Pareto Chart based on the data listed in the table above.