2D Zero Crossing Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 2D Zero Crossing Chart
--
--   Notes: The query below will work on the following database servers:
--          MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, MySQL, PostreSQL
--
--   ORACLE: To make the query below work in Oracle, add " FROM DUAL" at the end of each SELECT         
--   DB2: To make the query below work in DB2, add " FROM SYSIBM.SYSDUMMY1" at the end of each SELECT
-------------------------------------------------------------------------------------------------------------------------------------------------------------

select 'A' as category, 25 as s1, 24 as s2, 23 as s3, 22 as s4, 21 as s5
union
select 'B' as category, -15 as s1, -13 as s2, 0 as s3, 3 as s4, 5 as s5
union
select 'C' as category, 35 as s1, 2 as s2, 0 as s3, 5 as s4, -5 as s5
union
select 'D' as category, -7 as s1, -6 as s2, 0 as s3, 3 as s4, -3 as s5
union
select 'E' as category, 25 as s1, 24 as s2, 0 as s3, 5 as s4, -2 as s5
union
select 'F' as category, 0 as s1, 1 as s2, 3 as s3, 5 as s4, -3 as s5
union
select 'G' as category, 1 as s1, 0 as s2, 4 as s3, 6 as s4, -6 as s5
union
select 'H' as category, 9 as s1, 4 as s2, 2 as s3, 0 as s4, -3 as s5
union
select 'I' as category, -2 as s1, 0 as s2, 3 as s3, 5 as s4, 7 as s5
union
select 'K' as category, -1 as s1, -3 as s2, 0 as s3, 4 as s4, 6 as s5
union
select 'M' as category, 0 as s1, 1 as s2, 4 as s3, 6 as s4, 8 as s5
union
select 'O' as category, -5 as s1, -3 as s2, 4 as s3, 2 as s4, 0 as s5
union
select 'P' as category, 3 as s1, 0 as s2, 1 as s3, -4 as s4, -6 as s5
union
select 'T' as category, 1 as s1, 3 as s2, 0 as s3, -4 as s4, 8 as s5
union
select 'W' as category, -4 as s1, 0 as s2, -1 as s3, 5 as s4, 7 as s5
union
select 'Z' as category, 0 as s1, 3 as s2, 5 as s3, -2 as s4, -4 as s5
GO
.setResultSettings 'Index=1,
     CategoryFields="[category]",
     SeriesFields="[s1],[s2],[s3],[s4],[s5]",
     ShowChart=true,
     ShowToolbar=true,
     Paging=true,
     Split=300,
     Chart="{scatter,scatter,scatter,scatter,scatter}",
     RotX=324,
     RotY=0,
     RotZ=0,
     Zoom=40.0,
     ScaleData=true,
     ShowLegend=true,
     ShowGrid=true,
     Title="2D Zero Crossing Chart",
     PieExplode=0.0,
     GroupSmallValues=true,
     SmallValuesThreshold=3.0,
     PieLabelDistance=3.0,
     PieShowLines=false,
     LineWidth=1.0,
     Width=16.0,
     Height=10.0,
     Depth=8.0,
     SeriesSpacing=0.25,
     CategorySpacing=0.25,
     Font="Arial-6",
     TopColor="#D7DCF5",
     BottomColor="#EBF0F5",
     PanX=-4.299999,
     PanY=-5.900001,
     Lighting=Default,
     View2D=true,
     StackedPercent=false,
     ShowValueAxis=true,
     ShowCategoryAxis=true,
     ShowSeriesAxis=false,
     ValueAxisNumberFormat="###0",
     CategoryAxisNumberFormat="#,##0",
     NumericCategoryAxis=false,
     MergeAxis=true,
     SeriesAlias="default,default,default,default,default",
     SeriesSubType=",,,,",
     SeriesColumnType="Cube,Cube,Cube,Cube,Cube",
     SeriesMin="default,default,default,default,default",
     SeriesMax="default,default,default,default,default",
     SeriesColor="#008000,#FF00FF,#000080,#993300,#000000",
     SeriesFunctionMetaData="true,true,true,true,true",
     LegendPosition=Top Right,
     LegendWidthType=Exact,
     LegendWidth=100,
     LegendHeightType=Fit,
     LegendHeight=160,
     ShowFixedCategoryCount=false,
     FixedCategoryCount=1'