[prev in list] [next in list] [prev in thread] [next in thread]
List: gnuplot-info
Subject: Re: [Gnuplot-info] Pivot charts
From: Wilfried Kirschenmann <wilfried.kirschenmann () gmail ! com>
Date: 2011-08-29 13:42:21
Message-ID: CABeDAFhHF=6vu10dG=41BELCxkT-xxGjjQtF+j5D6TqW8NtAeA () mail ! gmail ! com
[Download RAW message or body]
Thanks a lot !
It does exactly what I need.
-----
Cordialement,
Wilfried Kirschenmann
"An expert is a person who has made all the mistakes that can be made in a
very narrow field."*
*Niels Bohr - *Danish physicist (1885 - 1962)*
On Mon, Aug 29, 2011 at 14:14, Thomas Sefzick <t.sefzick@fz-juelich.de>wrote:
> Wilfried Kirschenmann <wilfried.kirschenmann <at> gmail.com> writes:
>
> >
> > Hi !
> >
> > Is there any way to make pivot charts with gnuplot ?
> > While the rendering is not as perfect as with gnuplot (especially for
> latex
> > integration), this feature is quite cool for rendering complex data.
> > The basic idea is to provide several lines for the xtics.
> > Here is an example made with Excel 2010 :
> > http://img33.imageshack.us/img33/2893/2dxtics.png
> >
> > I think such a result can be obtained using xtics (for hbw) and xmtics
> (for
> > BlockSize). But I don't really know how.
> > Furthermore, I do not have any clue on how to have more than two lines
> with
> > such a solution.
> >
> > Does someone have any idea to do this with gnuplot ?
> >
> > Thank you !
> >
> > Wilfried K.
> >
> > PS : here is an example data file corresponding to the above example.
> > I can change the format if required. This is just to give an idea.
> >
> > hbw BlockSize 8 16 32 Colums
> > 2 50 4,17198 4,16793 3,89913 3,02885
> > 2 100 4,21908 4,21775 3,78856 3,05236
> > 2 200 4,24002 4,23781 3,66784 2,98845
> > 2 500 4,25776 4,23258 3,57771 2,64875
> > 2 1000 4,25216 4,22121 3,52153 2,37671
> > 3 50 5,9882 5,99525 5,46246 4,35246
> > 3 100 6,10275 6,09506 5,34337 4,3587
> > 3 200 6,13502 6,12775 5,1196 4,18988
> > 3 500 6,15232 6,12088 5,01207 3,55759
> > 3 1000 6,17388 6,14961 4,90655 3,07677
> > 4 50 7,16163 7,13301 6,40267 5,21287
> > 4 100 7,32222 7,28905 6,24217 5,15652
> > 4 200 7,38001 7,331 5,97103 4,57647
> > 4 500 7,40991 7,34586 5,85352 3,73692
> > 4 1000 7,43365 7,41626 5,53288 3,32743
> > 5 50 7,9758 7,93465 7,11937 5,82013
> > 5 100 8,18808 8,13962 6,96093 5,70663
> > 5 200 8,27238 8,19436 6,71287 4,79545
> > 5 500 8,32901 8,22072 6,4675 3,94972
> > 5 1000 8,36299 8,31976 5,98776 3,44018
> > 10 50 9,67729 9,56415 8,06963 7,245
> > 10 100 10,1679 9,94364 7,81294 5,88062
> > 10 200 10,3915 10,0978 7,71242 5,06986
> > 10 500 10,5716 10,3915 7,14721 4,28776
> > 10 1000 10,6165 10,0499 6,08965 3,43618
> > 15 50 10,0526 9,85771 8,06831 7,32775
> > 15 100 10,8091 10,3627 8,20089 5,86304
> > 15 200 11,1541 10,6012 8,0179 5,06813
> > 15 500 11,3891 10,9835 7,37601 4,28262
> > 15 1000 11,4836 9,64651 3,51027 3,4761
> > 20 50 10,0225 9,7607 8,05886 6,88685
> > 20 100 10,9907 10,3261 8,37316 5,80576
> > 20 200 11,5556 10,6838 8,1059 4,96834
> > 20 500 11,8022 10,6901 7,48284 3,82774
> > 20 1000 11,8772 8,60491 2,72766 2,84542
> > PPS :
> > In my real cases, each hbw may not have the same set of BlockSize values.
> >
> ------------------------------------------------------------------------------
> > EMC VNX: the world's simplest storage, starting under $10K
> > The only unified storage solution that offers unified management
> > Up to 160% more powerful than alternatives and 25% more efficient.
> > Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> > _______________________________________________
> > gnuplot-info mailing list
> > gnuplot-info <at> lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gnuplot-info
> >
> >
>
> mxtics have no label, so you can't use them.
> but you could use explicit xtics and labels:
>
> reset
> set macros
>
> datafilename="ts.dat"
>
> set decimalsign locale "de_DE"; set decimalsign "."
>
> set bmargin 4
> # the following line works for gnuplot version >4.4 only
> #set xtics scale 0,0 offset 0,0 rotate by 90 right
> # this work for gnuplot version >=4.4
> set xtics scale 0,0 offset 0,0 rotate by -90
> set yrange [0:14]
> set ytics 2
> set grid ytics
>
> # plot into table to set the xtics labels
> set table
>
> xticlabels="set xtics ("
> plot datafilename using ( \
> $0>0?xticlabels=xticlabels.",":0 , \
> xticlabels=xticlabels."\"".stringcolumn(2)."\" ".gprintf("%f",$0) ,
> \
> $0):3
>
> xticlabels=xticlabels.")"
> print xticlabels
> @xticlabels
>
> # plot into table to set labels and arrows
>
> label1=";set label "
> label2=",screen 0.001 center"
> xlabels=""
> arrow1=";set arrow "
> arrow2=" from first "
> arrow3=",0 to first "
> arrow4=",screen 0 nohead"
> xarrows=""
> nl=0
> xv=NaN
> xvs=""
> xl=NaN
> xr=NaN
>
> plot datafilename using ( \
>
> xv!=$1?xarrows=xarrows.arrow1.sprintf("%d",nl+1).arrow2.gprintf("%f",$0-0.5).\
> arrow3.gprintf("%f",$0-0.5).arrow4:0 , \
> xv!=$1?xr=($0-1):0 , \
> xv!=$1?(nl>0?xlpos=0.5*(xr-xl)+xl:0):0 , \
> xv!=$1?(nl>0?xlabels=xlabels.label1.sprintf("%d",nl)." \"".xvs."\" at
> first \
> ".gprintf("%f",xlpos).label2:0):0 , \
> xv!=$1?xvs=stringcolumn(1):0 , \
> xv!=$1?xl=$0:0 , \
> xv!=$1?nl=nl+1:0 , \
> xv!=$1?xv=$1:0 , \
> xtemp=$0 , \
> $0):3
> xlpos=0.5*(xtemp-xl)+xl
> xlabels=xlabels.label1.sprintf("%d",nl+1)." \"".xvs."\" at first
> ".gprintf("%f"\
> ,xlpos).label2
> print xlabels
> @xlabels
>
> xarrows=xarrows.arrow1.sprintf("%d",nl+2).arrow2.gprintf("%f",xtemp+0.5).arrow3\
> .gprintf("%f",xtemp+0.5).arrow4
> print xarrows
> @xarrows
>
> unset table
>
> # plot into dumb terminal (table doesn't work here) to set the xrange
> set term push
> set term dumb
> plot datafilename using 0:3 with linespoints, \
> '' using 0:4 with linespoints, \
> '' using 0:5 with linespoints, \
> '' using 0:6 with linespoints
> set term pop
>
> set xrange [GPVAL_X_MIN-0.5:GPVAL_X_MAX+0.5]
>
> replot
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> EMC VNX: the world's simplest storage, starting under $10K
> The only unified storage solution that offers unified management
> Up to 160% more powerful than alternatives and 25% more efficient.
> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> _______________________________________________
> gnuplot-info mailing list
> gnuplot-info@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gnuplot-info
>
------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management
Up to 160% more powerful than alternatives and 25% more efficient.
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
_______________________________________________
gnuplot-info mailing list
gnuplot-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gnuplot-info
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic