Page 1 of 1

Pivot Chart Like for TeeChart

Posted: Sun May 27, 2012 2:36 am
by 13045688
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

Re: Pivot Chart Like for TeeChart

Posted: Tue May 29, 2012 1:52 am
by 13045688
Hi,

Anybody got any idea on this?

Re: Pivot Chart Like for TeeChart

Posted: Tue May 29, 2012 4:10 pm
by 10050769
Hello tangone,

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

Thanks,

Re: Pivot Chart Like for TeeChart

Posted: Wed May 30, 2012 2:04 am
by 13045688
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.

Re: Pivot Chart Like for TeeChart

Posted: Wed May 30, 2012 7:24 am
by narcis
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.

Re: Pivot Chart Like for TeeChart

Posted: Wed May 30, 2012 8:41 am
by 13045688
Thanks, NarcĂ­s.

Please see attached.

Re: Pivot Chart Like for TeeChart

Posted: Thu May 31, 2012 12:41 pm
by 10050769
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 897 times
I hope will helps.

Thanks,

Re: Pivot Chart Like for TeeChart

Posted: Thu May 31, 2012 1:30 pm
by 13045688
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.

Re: Pivot Chart Like for TeeChart

Posted: Thu May 31, 2012 1:51 pm
by 10050769
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,