Setting to the dimensions I am using below is probably unreasonable. Let me know if this is an unlikely use case.

 

1. set your main application window to 996 x 669 and ensure your Grid Results pane is about 1/2 of the Query Analyzer's height. ( see attached datastudio properties file for exact dimensions of all panes )

2. execute the script below

3. after execution, and the chart is visible, click the "Fit to Image" button

4. Notice that the surface chart gets shoved off of the Chart Grid.

( the "Fit to Image" button in the GIF Animation is pressed a few more times to illustrate the shifting).

 

1. as an additional example, run the same process with the script on http://www.aquafold.com/chartgallery/3D-100-Stacked-Area-Chart-SQL-Script.html

2. the chart will stretch to fit the width when you press "Fit to Image" the first time.

3. if you press "Fit to Image" a second time to disable it, the view is changed and the chart is squashed to a dimension you didn't start with.

 

 

 

Version: 13.0-alpha-4

Build #: 30585

Build Date: 2012-Dec-12 09:25:17 AM

 

Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_35-b10

Memory: Max=891,092,992;  Total=448,135,168;  Free=344,103,704;  CPUs=8

 

In-Window Graphics Capabilities

Graphics Vendor: NVIDIA Corporation

OpenGL Renderer: Quadro FX 1700/PCI/SSE2

OpenGL Version: 3.3.0

Double-Buffering: Enabled

Anti-Aliasing: Enabled

Anti-Aliasing Sample Count: 16

Hardware Acceleration: Enabled

Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 0

Depth Bits: 24

Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16

Initialization Time: 1063 ms

 

 

Offscreen Graphics Capabilities

Graphics Vendor: Brian Paul

OpenGL Renderer: Mesa OffScreen

OpenGL Version: 2.1 Mesa 7.8.2

Double-Buffering: Disabled

Anti-Aliasing: Disabled

Anti-Aliasing Sample Count: 0

Hardware Acceleration: Disabled

Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 8

Depth Bits: 16

Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16

Initialization Time: 31 ms

Hardware PBuffer Available: No

Using PBuffer: No

Using Ram Buffer: Yes

Offscreen Rendering: Enabled

Offscreen Buffer Size: 800x600

 

 

 

-------------------------------------------------------------------------------------------------------- -----------------------------------------------------
-- 2D Surface 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 1 as category, 25 as s1, 45 as s2
union
select 2 as category, 10 as s1, -25 as s2
union
select 3 as category, 40 as s1, -5 as s2
union
select 4 as category, 70 as s1, 15 as s2
union
select 5 as category, 65 as s1, 50 as s2
union
select 6 as category, 40 as s1, -25 as s2
union
select 7 as category, 33 as s1, 23 as s2
union
select 8 as category, 95 as s1, 4 as s2
union
select 9 as category, 10 as s1, 12 as s2
union
select 10 as category, 70 as s1, 55 as s2
GO
.setResultSettings 'Index=1,
       CategoryFields="[category] ASC",
       SeriesFields="[s1],[s2]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{surface,surface}",
       RotX=324,
       RotY=0,
       RotZ=0,
       ZoomScalar=1.2025924,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="2D Surface Chart",
       TitlePosition="Bottom Center",
       TitleCategory="",
       TitleValue="",
       PieExplode=0.0,
       GroupSmallValues=true,
       SmallValuesThreshold=3.0,
       PieLabelDistance=3.0,
       PieShowLines=false,
       LineWidth=1.0,
       ShowMarkers=true,
       MapShowBackground=false,
       MapShowDetails=false,
       MapRange="",
       MapRangeColors="",
       Width=16.0,
       Height=10.0,
       Depth=6.0,
       SeriesSpacing=1.0,
       CategorySpacing=1.0,
       Font=Arial-6,
       LegendFontSize=1.0,
       SeriesFontSize=1.0,
       CategoryFontSize=1.0,
       ValueFontSize=1.0,
       TitleFontSize=1.75,
       AxisTitleFontSize=1.25,
       DataLabelFontSize=1.0,
       TopColor=#D7DCF5,
       BottomColor=#EBF0F5,
       PanX=-293.5,
       PanY=-160.7,
       Lighting=Bright,
       Opacity=1.0,
       View2D=true,
       FitChartToImage=false,
       StackedPercent=false,
       ShowValueAxis=true,
       ShowValueAxisTicks=true,
       ShowValueAxisLines=true,
       ReverseValueAxis=false,
       ShowCategoryAxis=true,
       ShowCategoryAxisTicks=true,
       ShowCategoryAxisLines=true,
       ShowSeriesAxis=false,
       ShowDataLabels=false,
       ValueAxisNumberFormat="###0",
       CategoryAxisNumberFormat="#,##0",
       CategoryAxisDateFormat="",
       CategoryAxisDateTimeFormat="",
       CategoryAxisTimeFormat="",
       SeriesAxisNumberFormat="",
       SeriesAxisDateFormat="",
       SeriesAxisDateTimeFormat="",
       SeriesAxisTimeFormat="",
       NumericCategoryAxis=false,
       MergeAxis=true,
       SeriesAlias="default,default",
       SeriesSubType=",",
       SeriesColumnType="Cube,Cube",
       SeriesMin="default,default",
       SeriesMax="default,default",
       SeriesColor="#3366ff,#993300",
       SeriesFunctionMetaData="true,true",
       ShowSeriesDataLabels="false,false",
       LegendPosition=Top Right,
       LegendWidthType=Exact,
       LegendWidth=100,
       LegendHeightType=Fit,
       LegendHeight=160,
       ShowFixedCategoryCount=true,
       FixedCategoryCount=0'