Charts Integration - Custom Chart Data

Pivot Grid Settings

Row Field Value Export Rule:

Export Cell Values less than:

as zero values

Chart Settings

Chart Type:

Show Point Labels

Page 5 of 9 (86 items)

Extended Price

Year

Quarter

Month

Category Name

Product Name

1994					1995												1996						Grand Total
3		4			1			2			3			4			1			2
August	September	October	November	December	January	February	March	April	May	June	July	August	September	October	November	December	January	February	March	April	May	June
$1,088.00	$1,931.20			$3,587.68	$2,418.08	$1,550.40		$1,632.00	$3,097.40	$892.50	$693.60	$4,131.00	$1,020.00	$4,428.50	$340.00	$2,210.00	$510.00	$4,998.00	$3,400.00	$2,978.40	$5,854.80	$63.92	$46,825.48
	$344.00	$86.00	$1,135.20	$86.00	$2,597.20	$1,290.00	$1,410.40	$206.40		$174.15		$806.24	$1,236.25	$498.80	$2,214.50		$602.00	$946.00	$1,182.50	$564.37	$4,171.00		$19,551.01
$161.50	$88.00		$16.00		$120.00	$238.00	$32.00	$24.00	$34.00	$128.50	$80.00	$35.00	$47.50	$167.00				$48.50	$237.50	$53.12	$137.50		$1,648.12
$200.00	$542.50		$688.00	$1,165.00	$1,559.00	$140.00	$27.00	$297.50	$190.00	$1,584.37	$1,865.00			$515.00	$875.00	$135.62	$1,671.25	$893.75	$437.50	$1,696.87	$187.50	$250.00	$14,920.86
		$662.40		$1,906.56	$1,670.40	$979.20			$259.20	$1,008.00	$306.00	$2,331.00	$540.00	$1,296.00	$1,773.00	$3,879.00	$691.20		$1,710.00	$684.00	$2,246.40		$21,942.36
$122.88		$921.60	$122.88						$1,280.00	$652.80	$288.00				$128.00	$320.00		$640.00	$192.00	$1,008.00	$2,696.00	$32.00	$8,404.16
$813.40	$945.20	$556.00	$2,397.75		$2,059.98		$1,390.00		$695.00	$1,914.00	$1,879.20	$417.60	$2,610.00			$1,461.60	$1,235.40	$1,722.60		$3,514.80	$1,287.60		$24,900.13
$168.00		$201.60	$672.00	$564.48		$504.00	$685.44	$441.00		$1,832.25	$924.00	$294.00	$210.00		$315.00	$105.00	$1,601.25	$693.00	$2,205.00	$1,065.75	$210.00	$210.00	$12,901.77
$346.56							$456.00			$1,396.50			$1,162.80	$3,800.00	$1,520.00					$1,900.00	$1,603.60	$72.20	$12,257.66
$3,938.00	$910.80	$1,430.00	$2,228.60		$528.00	$1,900.80	$4,048.00	$4,488.00	$2,860.00	$852.50	$2,420.00	$4,372.50		$715.00	$5,703.50	$4,881.25	$3,533.75	$7,749.50	$2,090.00	$220.00	$16,285.50		$71,155.70
$27,861.89	$25,485.27	$26,381.40	$35,931.72	$47,184.04	$45,239.63	$52,540.24	$47,201.45	$35,124.51	$56,455.65	$53,781.28	$36,362.79	$51,020.83	$47,287.66	$55,629.24	$66,461.43	$43,821.59	$71,398.41	$90,117.72	$103,519.69	$104,854.13	$129,247.25	$12,885.05	$1,265,792.87

Dairy Products

Camembert Pierrot

Fløtemysost

Geitost

Gorgonzola Telino

Gudbrandsdalsost

Mascarpone Fabioli

Mozzarella di Giovanni

Queso Cabrales

Queso Manchego La Pastora

Raclette Courdavault

Grand Total

Page 5 of 9 (86 items)

The chart showing Camembert Pierrot series, Fløtemysost series, Geitost series, Gorgonzola Telino series, Gudbrandsdalsost series, Mascarpone Fabioli series, Mozzarella di Giovanni series, Queso Cabrales series, Queso Manchego La Pastora series, Raclette Courdavault series.

Description

This demo illustrates how to customize data, passed from an ASPxPivotGrid Control to a Chart Control.

One of the ASPxPivotGrid's options is the capability to choose whether it's necessary to pass field values to a Chart as strings or as values, thus preserving initial data types. So, in the column area field group, date-time field values are passed to a Chart as date-time values. A Chart can show data using a lot of measure units: Year, Quarter and Month, and can calculate integrals for every unit. Collapsing a column field in a column field group increases the data scale, thus decreasing the number of available chart measure units.

In addition, an ASPxPivotGrid provides the capability to customize every field and cell value passed to a chart control. This demo contains three rules of exporting row field values: 'ProductName' and 'Category/ProductName' as strings and 'Encoded Product Category' by alphabetical encoding as characters. Cell value exporting in this demo is customized to skip values that are less than the specified threshold value.