Hi Max,

Thanks for the code. It has proven to be quite helpful. I have used the same code above to show a stacked column chart for each month of the year and data corresponding to them.

 However I am not able to edit the Y Axis. How do I do this? Also can you please share the code to create a legend for this kind of composite chart. Example of my code is below:

 String myconnstring;

SqlConnection myConn = new SqlConnection(myconnstring);

myConn.Open();

DataTable table = new DataTable();

DataTable dt = new DataTable();

DataSet ds = new DataSet();

dtime = System.

DateTime.Now;

String datet = dtime.ToString("MMMM");

SqlDataAdapter da = new SqlDataAdapter("exec dialerrep.findMonths", myConn);

da.Fill(table);

da.Fill(ds);

int mycols = table.Columns.Count;

dt.Columns.Add(

"Label", typeof(string));

for (int i = 1; i < mycols; i++)

{

"Val" + i, typeof(int));

}

int  j = 0;

foreach (DataRow dr in ds.Tables[0].Rows)

{

new object[] {dr[j]});

}

}

ultraChart1.ChartType =

new Rectangle(10, 10, 80, 80);

area.BoundsMeasureType =

MeasureType.Percentage;

LocationType.DataValues;

"CUSTOM", new MyLabelRenderer());

ultraChart1.LabelHash = labelHash;

"<CUSTOM>";

ultraChart1.Axis.X.Labels.SeriesLabels.Orientation =

TextOrientation.VerticalLeftFacing;

ultraChart1.Axis.Y.Labels.SeriesLabels.FormatString =

"<DATA_VALUE:##>";

ultraChart1.Axis.Y2.Labels.SeriesLabels.FormatString = "<DATA_VALUE:##>";

ultraChart1.Data.DataSource = table;

ultraChart1.Data.DataBind();

I'm not entirely sure what you mean by editing the Y axis. It wouldn't make much sense to change the y axis labels, because they are numeric, and any alteration of these numbers will misrepresent the data mapping. If you're referring to being able to change the labels in your custom label renderer's ToString method, then you have to set the FormatString on the Y axis labels to "Custom". This is what triggers the custom label renderer.

Also, I'm not sure why you're setting Y.Labels.SeriesLabels, because numeric axes don't have series labels. It should just be Y.Labels.

I also don't understand the purpose of the created chart area and the need for composite legend. Your chart doesn't appear to be a composite chart (ChartType isn't set to Composite), nor does it make use of Series objects. Are you not able to see the default legend in your chart?

Hi Max,

Please check out the attached chart. Currently the Y Axis shows decimal places which I need to remove and comes on both sides of the graph whereas I want it only on the left.

Also there seems to be several words that are coming on top of the graph by default (right above the 698). I am unsure as to why this is happening.

And I am not able to see the default legend in my chart too. I have attached the code I am using in my previous post.

Please advise. Thanks again!

Sharad

I think you're seeing the extra axis labels and the extra axes, because you have made them visible either somewhere else in code, or in the designer. I suggest resetting axis properties, or setting Y2 and X2 axes to not visible.

Here's a simple code example that generates a stacked column chart with a legend:

DataTable dt = new DataTable();
dt.Columns.Add("Value1", typeof(int));
dt.Columns.Add("Value2", typeof(int));
dt.Columns.Add("Value3", typeof(int));
dt.Columns.Add("Label", typeof(string));

dt.Rows.Add(new object[] { 1, 1, 1, "Jan" });
dt.Rows.Add(new object[] { 2, 1, 2, "Feb" });
dt.Rows.Add(new object[] { 4, 4, 2, "Mar" });
dt.Rows.Add(new object[] { 1, 3, 1, "Apr" });

ultraChart1.ChartType = ChartType.StackColumnChart;
ultraChart1.ColumnChart.ColumnSpacing = 1;

ultraChart1.Axis.X.Labels.SeriesLabels.Orientation = TextOrientation.VerticalLeftFacing;
ultraChart1.Axis.Y.Labels.ItemFormatString = "<DATA_VALUE:0>";

ultraChart1.Legend.Visible = true;

ultraChart1.Data.DataSource = dt;
ultraChart1.Data.DataBind();

Great! Thanks that worked. The chart comes up beautifully now except for the Y Axis... the data points still seem to be merged with the X Axis itself... is there a way to move the data points a little to the left so that they dont intersect with the axis?

Great! that worked! thanks!

Make sure chart.Axis.Y.Labels.HorizontalAlign is set to Far