Report Chart ALL in X Axis

[Craig]

I have a pretty simple bar chart and the first label on the X Axis is ALL. Where does this come from? It is not in the data.

 In the attached screenshot you will also see the bars are not centered above each label, why is this?

 And finally, the bars are very narrow, why is this and how can I make them wider?

[Craig]

I worked it out so don't worry.

[Katia]

Hello Craig,

I am glad to hear that.


For anyone concerned:

This result might occur when having an additional series grouping  - Groupings property in the SeriesGroups section of your Graph item. Please check Connecting to Data help article for details how the data is aggregated in a Graph item. Once the grouping is removed, the bars will be centered in their slots.

If you need to control the width of bars, please see How to: Change the Gap between the Bars help article. In general the steps would be:

- On the design surface select the target axis.
- In the Misc section set the Scale.SpacingSlotCount property according to your requirements.

Regards,
Katia
Telerik

[Ali]

hello

how did u remove "ALL"

Thank you

[Ali]

hello
how to remove "ALL"
Thank you

[Katia]

Hello Ali,

The approach is described in my previous post. Test removing the grouping for the Graph.SeriesGroup property. You can also check if the data is organized correctly for the Graph item following Connecting to Data help article.

If this approach does not help you can attach the problematic report in a support ticket so we can check the settings.


Regards,
Katia
Telerik by Progress

[Ali]

Hello

when removing the grouping for the Graph.SeriesGroup property, all the series disappeared and only "ALL"is kept on the XAxis.

COuld you please help me>?

[Katia]

Hello Ali,

It seems that some grouping for the Graph is missing or the data might not be grouped correctly. Note that CategoryGroups always needs to have a grouping expression - check this short video describing the scenario.

If the issue persists please send us a problematic report together with some test data in a support ticket so we can check the Graph's settings.


Regards,
Katia
Telerik by Progress

[Ali]

Hello

Thank you for your reply

It is true I dont need a categorygroup in my graph, at the same time i want to hide the expression "ALL". Is this possible?

[Katia]

Hi Ali,

In general, Category Groups always need to have a grouping expression. If it is missing the Graph will display "ALL" label for the categories.


Regards,
Katia
Telerik by Progress

[Ali]

Hello

I added categorygroup but it still has the same problem with the categories stated before the series on the XAxis.

here is the code:

 // 
            // graph2
            // 
            graphGroup3.Name = "categoryGroup1";
            this.graph2.CategoryGroups.Add(graphGroup3);
            monochromaticPalette1.BaseColor = System.Drawing.Color.DodgerBlue;
            this.graph2.ColorPalette = monochromaticPalette1;
            this.graph2.CoordinateSystems.Add(this.cartesianCoordinateSystem1);
            this.graph2.DataSource = this.facGovDataSource;
            this.graph2.Legend.Style.LineColor = System.Drawing.Color.LightGray;
            this.graph2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
            this.graph2.Legend.Style.Visible = false;
            this.graph2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(9.9921220680698752E-05D), Telerik.Reporting.Drawing.Unit.Cm(1.6000007390975952D));
            this.graph2.Name = "graph2";
            this.graph2.NoDataStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
            this.graph2.NoDataStyle.Visible = false;
            this.graph2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
            this.graph2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
            this.graph2.PlotAreaStyle.Visible = false;
            this.graph2.Series.Add(this.barSeries2);
            graphGroup6.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Governerate"));
            graphGroup6.Name = "governerateGroup";
            graphGroup6.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Governerate", Telerik.Reporting.SortDirection.Asc));
            this.graph2.SeriesGroups.Add(graphGroup6);
            this.graph2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19.311805725097656D), Telerik.Reporting.Drawing.Unit.Cm(7.6999998092651367D));
            this.graph2.Style.BorderColor.Top = System.Drawing.SystemColors.ActiveBorder;
            this.graph2.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
            graphTitle2.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
            graphTitle2.Style.LineColor = System.Drawing.Color.LightGray;
            graphTitle2.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
            graphTitle2.Text = "";
            this.graph2.Titles.Add(graphTitle2);
            // 
            // cartesianCoordinateSystem1
            // 
            this.cartesianCoordinateSystem1.Name = "cartesianCoordinateSystem1";
            this.cartesianCoordinateSystem1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
            this.cartesianCoordinateSystem1.XAxis = this.graphAxis4;
            this.cartesianCoordinateSystem1.YAxis = this.graphAxis3;
            // 

 

and i attached a screenshot

[Katia]

Hi Ali,

If the data you have does not have categories and you want to show only the series for a single category slot, you can leave the CategoryGroups grouping expression empty and then change the "ALL" label on the XAxis with CategoryGroup.Label property.

Check the attached report demonstrating this approach (can be opened with Standalone Designer R3 2016).


Regards,
Katia
Telerik by Progress

[Ali]

Solved!! Thank you very  much

[Vas]

Hi, 

I have created a Column chart with pointing series and category to the same field. But the bar is too thin. is there a way to increase the width. I'm using Telerik Stand alone report designer.

I have attached an image for reference.

Thanks in advance.

Regards,

Vas