ClusteredColumn Graph with negative values

frisco434 · Post by **frisco434** » Tue Nov 08, 2011 2:17 pm

Hello All !

im trying to get a clustered column graph to show negative values, it shows positive just fine, but all negative values do not show. Is there a property to show negative values? I have a series one with a positive value and one with a negative, only the positive shows up. See Below:
This is where i created the chart...

[left]Stimulsoft.Report.Chart.StiClusteredColumnArea Chart1_Area = new Stimulsoft.Report.Chart.StiClusteredColumnArea();
Chart1_Area.BorderColor = System.Drawing.Color.FromArgb(255, 88, 86, 75);
Chart1_Area.Brush = new Stimulsoft.Base.Drawing.StiGradientBrush(System.Drawing.Color.FromArgb(255, 255, 255, 255), System.Drawing.Color.FromArgb(255, 255, 255, 255), 90);
Chart1_Area.GridLinesHor = new Stimulsoft.Report.Chart.StiGridLinesHor(System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, true, System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, 0);
Chart1_Area.GridLinesHorRight = new Stimulsoft.Report.Chart.StiGridLinesHor(System.Drawing.Color.Silver, Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, System.Drawing.Color.Gainsboro, Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, 0);
Chart1_Area.GridLinesVert = new Stimulsoft.Report.Chart.StiGridLinesVert(System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, true, System.Drawing.Color.FromArgb(100, 88, 86, 75), Stimulsoft.Base.Drawing.StiPenStyle.Dot, false, 0);
Chart1_Area.InterlacingHor = new Stimulsoft.Report.Chart.StiInterlacingHor(new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(10, 138, 136, 125)), true);
Chart1_Area.InterlacingVert = new Stimulsoft.Report.Chart.StiInterlacingVert(new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(10, 138, 136, 125)), true);
Chart1_Area.XAxis = new Stimulsoft.Report.Chart.StiXBottomAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, true, 0F, true, Stimulsoft.Report.Chart.StiShowXAxis.Both);
Chart1_Area.XTopAxis = new Stimulsoft.Report.Chart.StiXTopAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, false, 0F, true);
Chart1_Area.YAxis = new Stimulsoft.Report.Chart.StiYLeftAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, true, 0F, true, Stimulsoft.Report.Chart.StiShowYAxis.Both);
Chart1_Area.YRightAxis = new Stimulsoft.Report.Chart.StiYRightAxis(new Stimulsoft.Report.Chart.StiAxisLabels("", "", "", 0F, new System.Drawing.Font("Tahoma", 8F), true, Stimulsoft.Report.Chart.StiLabelsPlacement.OneLine, System.Drawing.Color.FromArgb(255, 88, 86, 75), 0F, Stimulsoft.Report.Chart.StiMarkerAlignment.Right), new Stimulsoft.Report.Chart.StiAxisRange(true, 0, 0), new Stimulsoft.Report.Chart.StiAxisTitle(new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold), "", System.Drawing.Color.FromArgb(255, 88, 86, 75), true, System.Drawing.StringAlignment.Center), new Stimulsoft.Report.Chart.StiAxisTicks(true, 5F, false, 2F, 4, 0), Stimulsoft.Report.Chart.StiArrowStyle.None, Stimulsoft.Base.Drawing.StiPenStyle.Solid, System.Drawing.Color.FromArgb(255, 88, 86, 75), 1F, false, 0F, true);

Stimulsoft.Report.Chart.StiLegend Chart1_Legend = new Stimulsoft.Report.Chart.StiLegend();
Chart1_Legend.BorderColor = System.Drawing.Color.FromArgb(255, 95, 72, 29);
Chart1_Legend.LabelsColor = System.Drawing.Color.FromArgb(255, 95, 72, 29);
Chart1_Legend.MarkerSize = new System.Drawing.Size(10, 10);
Chart1_Legend.TitleColor = System.Drawing.Color.FromArgb(255, 95, 72, 29);
Chart1_Legend.Brush = new Stimulsoft.Base.Drawing.StiGradientBrush(System.Drawing.Color.FromArgb(255, 255, 255, 255), System.Drawing.Color.FromArgb(255, 255, 242, 199), 90);
Chart1_Legend.Font = new System.Drawing.Font("Tahoma", 10F, FontStyle.Bold);
Chart1_Legend.TitleFont = new System.Drawing.Font("Tahoma", 14F, System.Drawing.FontStyle.Bold);
Chart1_Legend.Columns = oDt.Columns.Count; // dtChartData.Rows.Count;
Chart1_Legend.VertAlignment = Stimulsoft.Report.Chart.StiLegendVertAlignment.Top;
Chart1_Legend.HorAlignment = Stimulsoft.Report.Chart.StiLegendHorAlignment.Right;

//Stimulsoft.Report.Chart.StiTwoColumnsPieLabels Chart1_SeriesLabels = new Stimulsoft.Report.Chart.StiTwoColumnsPieLabels();
//Stimulsoft.Report.Chart.StiOutsidePieLabels Chart1_SeriesLabels = new Stimulsoft.Report.Chart.StiOutsidePieLabels();
Stimulsoft.Report.Chart.StiNoneLabels Chart1_SeriesLabels = new Stimulsoft.Report.Chart.StiNoneLabels();
Chart1_SeriesLabels.BorderColor = System.Drawing.Color.FromArgb(255, 105, 105, 105);
Chart1_SeriesLabels.LabelColor = System.Drawing.Color.FromArgb(255, 105, 105, 105);
Chart1_SeriesLabels.LegendValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.ArgumentValue;
Chart1_SeriesLabels.MarkerSize = new System.Drawing.Size(8, 6);
Chart1_SeriesLabels.ValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.Argument;
Chart1_SeriesLabels.ValueTypeSeparator = "-";
Chart1_SeriesLabels.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.White);
Chart1_SeriesLabels.Font = new System.Drawing.Font("Tahoma", 10F, FontStyle.Bold);

Chart1.Area = Chart1_Area;
Chart1.Legend = Chart1_Legend;
Chart1.Page = page;
Chart1.Parent = reportBand;
Chart1.SeriesLabels = Chart1_SeriesLabels;
Chart1_Area.Chart = Chart1;
Chart1_Legend.Chart = Chart1;

Chart1_SeriesLabels.Chart = Chart1;
Chart1.Title.Text = sReportTitle;
Chart1.Title.Visible = true;
Chart1.Title.Font = new System.Drawing.Font("Tahoma", 16F, FontStyle.Bold);
//Chart1.Series.Clear();
//Chart1.Series.AddRange(new Stimulsoft.Report.Chart.StiSeries[] {
// SeriesData});

Chart1.Series.Clear();
for (int i = 1; i < oDt.Columns.Count; i++)
{
Stimulsoft.Report.Chart.StiCenterAxisLabels SeriesData_SeriesLabels = new Stimulsoft.Report.Chart.StiCenterAxisLabels();
SeriesData_SeriesLabels.BorderColor = System.Drawing.Color.Black;
SeriesData_SeriesLabels.LabelColor = System.Drawing.Color.Black;
SeriesData_SeriesLabels.LegendValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.ArgumentValue;
SeriesData_SeriesLabels.MarkerSize = new System.Drawing.Size(8, 6);
SeriesData_SeriesLabels.ValueType = Stimulsoft.Report.Chart.StiSeriesLabelsValueType.ArgumentValue;
SeriesData_SeriesLabels.ValueTypeSeparator = "-";
SeriesData_SeriesLabels.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.White);
SeriesData_SeriesLabels.Font = new System.Drawing.Font("Tahoma", 10F, FontStyle.Bold);
SeriesData_SeriesLabels.Chart = Chart1;

Stimulsoft.Report.Chart.StiClusteredColumnSeries SeriesData = new Stimulsoft.Report.Chart.StiClusteredColumnSeries();
SeriesData.ArgumentDataColumn = oDt.TableName + ".argumentdata";
SeriesData.Title = new StiTitleExpression(oDt.Columns.Caption);
SeriesData.SortBy = Stimulsoft.Report.Chart.StiSeriesSortType.Argument;
SeriesData.BorderColor = System.Drawing.Color.FromArgb(255, 155, 155, 155);
SeriesData.ValueDataColumn = oDt.TableName + ".valuedata_" + i.ToString();
SeriesData.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.White);

SeriesData.Chart = Chart1;
SeriesData.SeriesLabels = SeriesData_SeriesLabels;

Chart1.Series.Add(SeriesData);
}

reportBand.Components.Add(Chart1);[/left]

Post by **HighAley** » Thu Nov 10, 2011 2:08 am

Hello.

Which version of Stimulsoft Reports.Net do you use?

Thank you.

frisco434 · Post by **frisco434** » Thu Nov 17, 2011 10:17 am

runtime version: v2.0.50727
version: 2010.1.700.0

sorry about the delay response

Post by **HighAley** » Fri Nov 18, 2011 7:10 am

Hello.

frisco434 wrote:runtime version: v2.0.50727
version: 2010.1.700.0

sorry about the delay response

Please, send us your project with data to reproduce your issue.

Also try to check our latest prerelease build. We made some improvements.

Thank you