Pivot Chart Like for TeeChart

[tangone]

Dear Sir/Madam,

Greetings!

I am using TeeChart for .Net v3 and I would like to plot something like the image attached which is an Excel Pivot Chart.
Could you please give me an example how I can do that (including the X-Axis lables)?

Thanks.

Rgds,
tangone

[tangone]

Hi,

Anybody got any idea on this?

[Sandra]

Hello tangone,

We are working with this, but would be very helpful if you can send me your data to make the test.

Thanks,

[tangone]

Hi Sandra,

Glad to hear that it is being worked out.
Please see attached image (I was not allowed to upload Excel file by the way) for the sample.

Code: Select all

Year	LINE_CD	OUT_QTY	PLAN_QTY
Y2006	HA01		100		200
			HA02		50		150
			HA03		300		232
			HA04		89		288
			HA05		232		328
			HA06		132		32
Y2007	HA01		38		188
			HA02		27		132
			HA03		119		172
			HA04		382		121
			HA05		177		232
			HA06		183		48
Y2008	HA01		48		98
			HA02		59		181
			HA03		290		32
			HA04		188		48
			HA05		172		188
			HA06		127		23

Thanks.

[Narcís]

Hi tangone,

Please see attached image (I was not allowed to upload Excel file by the way) for the sample.

You can compress it in a zip package and attach it to the forums.

[tangone]

Thanks, Narcís.

Please see attached.

[Sandra]

Hello tangone,

Sorry for the delay. I have made a simple code where reproduce the chart you want achieve, using your data in two xml files and DataSet. Please, check if my project works as you expect. On the other hand, we have find some information as you do to made Pivot Charts using c# and I recommend you take a look in this link.

PivotSample.zip

(32.97 KiB) Downloaded 793 times

I hope will helps.

Thanks,

[tangone]

Hi Sandra,

Thanks for the sample provided, and I am sorry that I did not mention I wanted to have it in web application.
Would it be difficult to convert it to web application?

Thanks.

[Sandra]

Hello tangone,

Thanks for the sample provided, and I am sorry that I did not mention I wanted to have it in web application.
Would it be difficult to convert it to web application?

Isn't dificult, you can take a look in our tutorials, concretly in Tutorial9 - ASP.NET Applications or in Demo ASP.Net that is installed with TeeChartFor.Net.

On the other hand, I have forgotten tell you as you have other option to achieve a simple pivot charts, you only need use CrossTab component of TeeChart, you can find an example, in Demo project All Features\Welcome !\Datasets\CrossTab Charts

Thanks,