SQL Server 2000 Northwind Database
if you execute the below query and then in Chart Properties in Axes
tick Merge Series axis. the chart displays negative values, which is incorrect....See attached pic
select 1 as category, 75 as s1, 35 as s2
union
select 2 as category, 45 as s1, 55 as s2
union
select 3 as category, 55 as s1, 90 as s2
union
select 4 as category, 45 as s1, 45 as s2
union
select 5 as category, 65 as s1, 85 as s2
union
select 6 as category, 40 as s1, 60 as s2
union
select 7 as category, 80 as s1, 35 as s2
union
select 8 as category, 45 as s1, 55 as s2
union
select 9 as category, 45 as s1, 90 as s2
union
select 10 as category, 20 as s1, 45 as s2
GO
.setResultSettings 'Index=1,
CategoryFields="[category]",
SeriesFields="[s2],[s1]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=300,
Chart="{column,area}",
RotX=317,
RotY=1,
RotZ=0,
Zoom=20.606081,
ScaleData=true,
ShowLegend=true,
ShowGrid=true,
Title="3D Bar Area Combination Chart",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
Width=16.0,
Height=10.0,
Depth=4.0,
SeriesSpacing=0.45,
CategorySpacing=0.45,
Font="Arial-6",
TopColor="#D7DCF5",
BottomColor="#EBF0F5",
PanX=-8.0,
PanY=-5.0,
Lighting=Default,
View2D=false,
StackedPercent=false,
ShowValueAxis=true,
ShowCategoryAxis=true,
ShowSeriesAxis=false,
ValueAxisNumberFormat="###0",
CategoryAxisNumberFormat="#,##0",
NumericCategoryAxis=true,
MergeAxis=false,
SeriesAlias="default,default",
SeriesSubType=",",
SeriesColumnType="Cube,Cube",
SeriesMin="default,default",
SeriesMax="default,default",
SeriesColor="#FF0000,#333399",
SeriesFunctionMetaData="true,true",
LegendPosition=Top Right,
LegendWidthType=Exact,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=false,
FixedCategoryCount=1'
|
42 KB
Use zero as minimum value for all-positive series
Issue #2431 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Use zero as minimum value for all-positive series