Diagramgalleri - Aqua Data Studio v7.5
Eksempler på diagram-screenshots
    Områdediagrammer
    Søjlediagrammer
    Boblediagrammer
    Kombinationsdiagrammer
    Finansielle diagrammer
    Linjediagrammer
    Cirkeldiagrammer
    XY-punktdiagrammer
    Grundfladediagrammer
Områdediagrammer SQL Scripts
    3D-områdediagram SQL Script
    Stablet 3D-områdediagram SQL Script
    100% stablet 3D områdediagram SQL Script
    Nul-akse 3D-områdediagram SQL Script
    2D-områdediagram SQL Script
    Stablet 2D-områdediagram SQL Script
    100% stablet 2D områdediagram SQL Script
    Nul-akse 2D-områdediagram SQL Script
Søjlediagram SQL Scripts
    3D-søjleklyngediagram SQL Script
    Liggende 3D søjlediagram SQL Script
    Liggende 3D nul-akse søjlediagram SQL Script
    Hældende 3D søjlediagram SQL Script
    3D pyramidediagram SQL Script
    Stablet 3D-søjlediagram SQL Script
    Tyndt 3D-kolonnediagram SQL Script
    3D-søjlediagram SQL Script
    3D-cylinderdiagram SQL Script
    Negativt 3D-søjlediagram SQL Script
    2D-cylinderdiagram SQL Script
    Negativt 2D-søjlediagram SQL Script
    Liggende 2D-søjlediagram SQL Script
    Liggende 2D nul-akse søjlediagram SQL Script
    2D-søjleklyngediagram SQL Script
    Stablet 2D-søjlediagram SQL Script
Boblediagram SQL Scripts
    3D-boblediagram SQL Script
    2D-boblediagram SQL Script
Kombinationsdiagram SQL Scripts
    3D søjle-område kombinationsdiagram SQL Script
    3D søjle-linje kombinationsdiagram SQL Script
    2D søjle-område kombinationsdiagram SQL Script
    2D søjle-linje kombinationsdiagram SQL Script
Finansielt diagram SQL Scripts
    3D-høj-Lav-Luk diagram SQL Script
    3D-lysestagediagram SQL Script
    2D-høj-Lav-Luk diagram SQL Script
    2D-lysestagediagram SQL Script
Linjediagram SQL Scripts
    3D-serielinjediagram SQL Script
    Stablet 3D-linjediagram SQL Script
    Nul-akse 3D-XY-diagram SQL Script
    2D-serielinjediagram SQL Script
    Stablet 2D-linjediagram SQL Script
    Nul-akse 2D-XY-linjediagram SQL Script
Cirkeldiagram SQL Scripts
    3D-cirkeldiagram SQL Scripts
    Eksploderende 3D-cirkeldiagram SQL Script
    2D-seriecirkeldiagram SQL Script
    2D-cirkeldiagram SQL Script
    Eksploderende 2D-cirkeldiagram SQL Script
    2D-seriecirkeldiagram SQL Script
XY-diagram SQL Scripts
    3D XY-diagram SQL Script
    Lineært 3D-regressionsdiagram
    Nul-kryds 3D-diagram SQL Script
    2D XY-diagram SQL Script
    Lineært 2D-regressionsdiagram SQL Script
    Lineært 2D-nul-kryds diagram SQL Script
Grundfladediagram SQL Scripts
    3D-grundfladediagram SQL Script
    2D-grundfladediagram SQL Script

100% stablet 2D områdediagram SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 100% stablet 2D områdediagram
--
--   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 1 as category, 40 as s1, 75 as s2
union
select 2 as category, 5 as s1, 45 as s2
union
select 3 as category, 20 as s1, 80 as s2
union
select 4 as category, 70 as s1, 25 as s2
union
select 5 as category, 20 as s1, 75 as s2
union
select 6 as category, 5 as s1, 75 as s2
union
select 7 as category, 33 as s1, 60 as s2
union
select 8 as category, 95 as s1, 80 as s2
union
select 9 as category, 10 as s1, 50 as s2
union
select 10 as category, 70 as s1, 90 as s2
GO
.setResultSettings 'Index=1,
     CategoryFields="[category]",
     SeriesFields="[s1],[s2]",
     ShowChart=true,
     ShowToolbar=true,
     Paging=true,
     Split=300,
     Chart="{stackedarea,stackedarea}",
     RotX=324,
     RotY=0,
     RotZ=0,
     Zoom=37.0,
     ScaleData=true,
     ShowLegend=true,
     ShowGrid=true,
     Title="100% stablet 2D områdediagram",
     PieExplode=0.0,
     GroupSmallValues=true,
     SmallValuesThreshold=3.0,
     PieLabelDistance=3.0,
     PieShowLines=false,
     LineWidth=1.0,
     Width=16.0,
     Height=10.0,
     Depth=12.0,
     SeriesSpacing=0.5,
     CategorySpacing=0.5,
     Font="Arial-6",
     TopColor="#D7DCF5",
     BottomColor="#EBF0F5",
     PanX=-5.5999994,
     PanY=-5.5999994,
     Lighting=Bright,
     View2D=true,
     StackedPercent=true,
     ShowValueAxis=true,
     ShowCategoryAxis=true,
     ShowSeriesAxis=false,
     ValueAxisNumberFormat="###0",
     CategoryAxisNumberFormat="#,##0",
     NumericCategoryAxis=false,
     MergeAxis=true,
     SeriesAlias="default,default",
     SeriesSubType=",",
     SeriesColumnType="Cube,Cube",
     SeriesMin="default,default",
     SeriesMax="default,default",
     SeriesColor="default,default",
     SeriesFunctionMetaData="true,true",
     LegendPosition=Top Right,
     LegendWidthType=Exact,
     LegendWidth=100,
     LegendHeightType=Fit,
     LegendHeight=160,
     ShowFixedCategoryCount=true,
     FixedCategoryCount=0'