x-axis-labels not showing

[Tobias]

I'm having trouble getting my x-axis labels to show.

<chartfx7:Chart ID="Chart1" runat="server" ContextMenus="False" Width="300px" Height="200px">  <Series>   <chartfx7:SeriesAttributes Gallery="Lines" Color="Red" MarkerShape="None" Text="gräns 1" />   <chartfx7:SeriesAttributes Gallery="Lines" Color="Red" MarkerShape="None" Text="gräns 2" />   <chartfx7:SeriesAttributes Color="153, 204, 255" Gallery="Lines" Text="bud" />   <chartfx7:SeriesAttributes Color="51, 102, 255" Gallery="Lines" Text="prev" />   <chartfx7:SeriesAttributes Color="0, 0, 0" Gallery="Bar" Text="value" />  </Series>  <AllSeries Gallery="Bar"></AllSeries>  <LegendBox Visible="False"></LegendBox>  <SpecialObjects>   <chartfxadornments:SimpleBorder AssemblyName="ChartFX.WebForms.Adornments" Type="None"></chartfxadornments:SimpleBorder>   <chartfxadornments:SolidBackground AssemblyName="ChartFX.WebForms.Adornments"></chartfxadornments:SolidBackground>   <chartfx7galleries:Bar></chartfx7galleries:Bar>  </SpecialObjects>  <AxisY Title-Text="" LabelsFormat-Format="Currency"></AxisY>  <AxisX Title-Text="Period" LabelAngle="45" LabelsFormat-Format="Number"></AxisX>  <MainPane AxisY-Title-Text="" AxisY-Max="260000" AxisY-Min="0" /></chartfx7:Chart>

Code behind:

DataTable

dt = new DataTable();dt.Columns.Add("period");dt.Columns.Add("grans1");dt.Columns.Add("grans2");dt.Columns.Add("value");dt.Columns.Add("bud");dt.Columns.Add("prev");

DataRow dr = dt.NewRow();dr.ItemArray = new Object[] { "200801", 130000, 250000, 20000, 23000, 25000 };dt.Rows.Add(dr);dr = dt.NewRow();dr.ItemArray = new Object[] { "200802", 130000, 250000, 40000, 38000, 42000 };dt.Rows.Add(dr);dr = dt.NewRow();

// ...up to 200812

Chart1.AxisX.LabelsFormat.Format = ChartFX.WebForms.

AxisFormat.None;Chart1.AxisY.LabelsFormat.Culture = new System.Globalization.CultureInfo("sv-SE");

Chart1.DataSourceSettings.Fields.Add(new ChartFX.WebForms.FieldMap("period", ChartFX.WebForms.FieldUsage.XValue));Chart1.DataSourceSettings.Fields.Add(new ChartFX.WebForms.FieldMap("grans1", ChartFX.WebForms.FieldUsage.Value));Chart1.DataSourceSettings.Fields.Add(new ChartFX.WebForms.FieldMap("tgrans2", ChartFX.WebForms.FieldUsage.Value));Chart1.DataSourceSettings.Fields.Add(new ChartFX.WebForms.FieldMap("budt", ChartFX.WebForms.FieldUsage.Value));Chart1.DataSourceSettings.Fields.Add(new ChartFX.WebForms.FieldMap("prev", ChartFX.WebForms.FieldUsage.Value));Chart1.DataSourceSettings.Fields.Add(new ChartFX.WebForms.FieldMap("value", ChartFX.WebForms.FieldUsage.Value));Chart1.DataSource = dt;Chart1.DataBind();

I have also tried to explicitly apply a value:

Chart1.AxisX.Labels[0] = "Jan";Chart1.AxisX.Labels[1] = "Feb";

...but no success. Any help is appreciated!

[Frank]

Since "period" is a string, you want to assign it as labels not as X-Values:

Chart1.DataSourceSettings.Fields.Add(new ChartFX.WebForms.FieldMap("period", ChartFX.WebForms.FieldUsage.Label));

 Also, your columns don't have a type, therefore, they are all String Columns. You can change that by doing:

dt.Columns.Add("grans1", typeof(double));

[Tobias]

Thank you Francisco!

This resolved my problem!

[nuwan]

Hi frank

 I have the same type of a issue. hope you can help me with that.

I have a string value which should be used as the X axis value,but it in not poissible, So i created another series with numbers corresponding to the text keys,and then added the string series as KeyLable. But key values are not displayed. Please help me to solve this issue

pls see the code

 

  Dim dtb1 As New DataTable
  dtb1.Columns.Add("Time", Type.GetType("System.String")) 'this is lable field
  dtb1.Columns.Add("key1", Type.GetType("System.Int32")) 'this is key field

dtb1.Columns.Add("val1", Type.GetType("System.Int32")) 'this is value field

 

Chart1.DataSourceSettings.Fields.Add(New FieldMap("key1", FieldUsage.XValue))
  Chart1.DataSourceSettings.Fields.Add(New FieldMap("Time", FieldUsage.KeyLabel))
  Chart1.DataSourceSettings.Fields.Add(New FieldMap("val1", FieldUsage.Value))

 exampls data

time,key1,val1

"00",0,12

"15",15,123

"60",60,456

"60+",70,12

 the reason why i need to add a XValue field is to get a CustomGridLine.

 pls see the image below

http://community.softwarefx.com/forums/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVgAAAELCAIAAAATFAlOAAASGUlEQVR4nO2dYZazKgyG3RN7Yk/ZU/aU+YG1jrUUFTXg85x7OFy+aZphbHhNIwwGAI9nuNsBALgfAgEAEAgAgEAAAEYgAAAjEACAEQgAwAgEAGAEAgCw8kCgqjFKjDHGGOIb+vTpO+5LjFFV6wQCEYkxiqiqqb5ao0+fvvu+agi/Y8HvQKCqMUqyQ0tL22L7Uxf8DgSjFjB7R5p3a4wzzngD46ohRtU0sDcQJFsHYxItLe19bdL1+i0WlAWCRYyZ34cwzjjjLYxPiiCxORCEGC+PXrS0tJXbOAsE9kGhIki2VN926dOn31I/fXcwYf8pCgT2tktLS9tkGw/eGqzkCMySIcYZZ7yVcXIEtLS0dRRBsqX6tkufPv2W+uQIaGlpq+YIzIw+ffot9o/mCEZFYGZm6eX06dNvrl8zR/C2S58+/ab6p+UI7GOEccYZ9zpeP0cweyfGGWe8jfFKdQRmb7v06dNvrU+OgD59+nVzBGb06dNvsV8nR/C2O/bnLeOMM+59vE4dQWL+8rklxhln3Pk4OQL69OmfkSOY/SvjjDPexPhJOQL69Om31K9TR5CYv5o+ffoN9ckR0KdPv1aOYDYyN8I444w3MU6OgD59+lXrCACgUWrnCCz15y3jjDPufbx+jmAO44wz3sQ4OQL69OlXrSMAgCOIahQNUeTjo3g2NRSBmU3RZey/DTHOOOMl4zFKiDKEsU3nlF/mT50cAQAcQURDlBA1iIWoIeoQROQ6XVAvR2Bmq/chZ46rqqRW6NNvuP/SAjq8okAamX5Gxyv/rM9X23UEnx4DtMgoB/79JyHK9ANnX+oVFEHqzF97WX/h85H+XIYdtDn55MSO/V8BDtqsOecf9667+63PuYiOiuDd/gsEFa/P1X7bOQIUAfRBjO+7gxQC5lHAmlAE85f9jzenj3+J33vsy0r83unnx5p5sx1brieH5n/u3hE79p7zCtfD4vK93Y7l1vB/46Kv7OD4rUFMUWDuklW9PlfHm6wjmC5HFAG0i6rF13cE8dcXBA0ogtSZv/RfvDlzfOHyEftf71e321/XKffZMZvi5lE79qlT9tqxxZp5wM4/neLDjk1z/uXnRScVoCXzUPH6XB0nRwBwNVF0EgKFl3ADiuC8+5af49yvFo4X3q+WjK/rlF1+PjAvozp+UzhEEd1gv+L1uTpOHQHARUx5wRA3X7gNKIJzHCui4uxULOes5VXF386nKfHn1UkTpapRxozAz7zgKmeXG5MjADgX2Z4R+KQBRfDNxfPGMx7vtv+5Ou32c/EDt9ux73UEO+x/c2+H/c/73n127COfcrsdM0vPEk81AlMUuP36XB1vso5gAkUAbtF5RuDwddqAIjjHsSK4X23aVK95mVdGQEPU134dR6l4fa5CjgCgJqIaXkkBh5HuG2fWEVjp+DAM0/jwosTO6v1q+fvOx1e+p91lxz7uM2+3Y7kaPp0mvND+e84Lfj7/dxznvOx98+OLi/cuO6lSKGUERNYfIr79+lwdv7+OYP6xn1838/43UAQH2TrhR+z3zZQXDFHP+KavAUVw5O3TheIhEDhUcWff2H+b4YUom/+NhmFIImL1Jxcjn/+6oJu8jKgNr51F5oKuikvjW/RdR+AnEDyQ1Rn+/BMsgkLmj5Uf6RLV94MDp35WG1AE3zz8Ob64pFTXA8H08/q6TZoIEoY4DDLQ7mmHtfHho/85MvXnLP718+dpD7RBwtbP16bxO+sIFheSoQiupVwRZP41b7BjRfAWApdcgw0oguNOeLg16OZ+dZOprfI+5Qj2vfaTRvMys2eHcldN5RzBE+oIvmWbfoIiOE4+4WfZ6Fzy2p5EgW7ZU6j2Wz9AEewGRVCIw7XXWptzkfU9hTI/X8Wl0drZioBAAPCTHXsK1QVFkKPvNfOCHMG9pppQBKo7K4WoI7iC5C2KAE7lyJ5CdWlAEdw4Q09bnXbjUO+Y7zlXZ3sKec8RsB8B9EeVPYXq0oAiOMexIh6yOvVqyqFOSccNLPYUutelxCPqCHbjJVxDF6ibjMAnKIIcKIJCHK695mnO5xmBUGtPoUflCLoJBPBYRHUsExA9+/O2GxRBjr7XTJ839p0pgteeQikvuPIZuN6lVagjWIc6AjjI7kqhW2hAEVBHsMChInCod+zWORfRISz3FNphJ/8WtUyZ/xwBdQTQFnrVnkJ1aUARnONYEX2sTmfbcWvqep0SZ08Qrr7E50QZdQR5UARQzpQXnO0z3gwoghwogkIeniMQ1TDWCPx4T59zbv5zBN0EAugStdv2FKoLimCFjMe7cbhm+rxfbUgRbN1T6Judii7thjqCHCgC+MbtewrVpQFFQB3BAoeKwKHesdPmXNWmjMDW39vnnJv/HAF1BOAKkXe94N2+1KQBRXCOY0X4X5082HFrqq5O0cN7CpnXiTLqCPKgCCDhcE+huqAIcqAICuk4R6Cv88iHcHRPIfM65+Y/R9BNIIAW8bPL8NmgCFbIeLwbh2umz/tVJ4rglRHQEDV+eXBgn9kqduqaMuoI8qAInomohvdhxI+4BhpQBNQRLHC4OjnUO7Z3zv/vMqx1vfI55+Y/R3CwjuDncbp5UAQdo2oxSpR3dbA2tadQXRpQBLvf+/O87cwJ3Kvcvjqt4nB18mkqs2ZG0RAkfRcQooQo+V2G+55ze04dwe2BAPyg76eGLYyVgpJ2FmtoT6G69KwIxveY3QigCM6wY63lCJIEGMZcgE66IPPWfc+5+c8RXKkIkn/JzalP21+bAsGUDpieIPLg213t54ezLvcrgvGd7r41cLhmVvztfJr6tspFkeleIGmBVDV4gVc+J8r6riNwlSwEJ+g7U/iOBRVLhhqlAUVwxEM/Xx+SIyjk1Dmf7ykUooQgQ4ix4BGCvufc/OcI2I8AatHZnkJ1aUARnONYESiCpk29K4Vs2lNoZ6VQ33Nuz6kj2AcLRwc85wnCI6AIVsh4vJu+FYHTHIFofJ1BeHCv8b7n3PznCFAEsA9RMgIbQBHk8Bm/Ha5O3kxNZxD+OnmolL7n3PquIzgOS0lz6DwjwF+vmAYUwY1/TnIEhXjQOzrbZTg9Qcicb7DmPEdAHQGUoPouE3jsE4RHaEARnONYESiCJkxN55HP9xQyHzrlJDt1TRl1BHlQBP557J5CdUERrJDxeDd9K4Jb1l5RmzICqy9izjdYc54jQBHAKvMHB+72pQdQBDl8xm+Hq9OVplKlUNIC+XWsb0VQOUdAHUEGFIE3/j1BeLczPdGAIqCOYIHD1ekCvTNVCg1RCieTOd9gzXmOgDoCsP9PEN7tS580oAjOcawIFMHtpnRWL7g1L0hephzqCFbQ8RtEFMHNyCsjEGTl6oGKoAhyoAgKOWPtXT2DcJtXzHm5Nec5gm4CAZTDE4TXgyLI4TN+O1ydqrlklj+DcBN9KwLqCK6D9ehKVC3wBOFNNKAIqCNY4HB1Ov65jbMTB2o5xpxvsOY8R0AdwROIPEF4Nw0ognMcKwJFcLapaYvR8KoZ9rlm9jTnq1BHsAJ1BBegalGMJwidgCLIgSIoZOvaOz+DcPFa5ryQZ+UIugkEMMEZhA7pXBE4Og2Z+1UrOoMQRXC9Keu7jmDx+V8dycOCVRHOIPRMA4qgioe3B4K+V6f8eqK64QxC5ryQZ+UIatUR3B4IHgtnEDZBA4rguBPTZz4fCJJ/+p/5+JFWqlrz1n6bq8UZhBd7JbLuVR9t9evTzuT+OoJvH34UwakoTxA2xdl/pPu/Nfj2v+QIav52s/tV/X8G4db3YM4LeVaO4OC3BnMWgyUWWMu2opxB2CadK4KD+IzfDlenZOpfRmCvcRTB9aas7zqC46AIyuEMwqZpQBHc+GFkdSrh5xmEm2DOC3lWjoD9CJzDGYR90IAiOMexHBmPd9Pf6jQ/g7BiFPC5ZjqZ85NMGfsR5EERfIMzCDsDRZADRbD2qpUzCB2uvdbRnK/yrBxBN4GgDziDsFdQBDl8xu9bVicd6wXX84I+b337VgTUEVwHiiDBGYTd04AioI5gwcWrU8kZhA71jrU85yU8K0dwSx2B/n9I8yGoWowS5f2MAE8QPocGFME5jhXxnNUpioYgIaZ9hCRE2XQGoc9bX4c6xedEGXUEeR6yDqrqa09RC+NZA5J2FuMJwoeAIsjxEEWQJMAw5gJ00gXlb+Rw7TXfc36cZ+UIugkEnkmBYEoHvPpyt19wHSiCHD7jd/XVKYpM9wJJCwxBNj0+4PPWt29FQB3BdTxBEahOmcJ3LIj1ziaHJmhAEVBHsKDi6jQ/gzBECUGGEOP2jccd6h3zOudV7NjTcgTUEZwHTxDCRAOK4BzHiuh1dVL9fQbhxS6dYcqhTvE5UUYdQZ4uFYGMlQLsKQRvUAQ5OlMEqlONgB7ZaPgTh2uv+Zjzk+zY03IE3QSC25F5RqCfXwvqgCLI4TN+b/VKZ08QLo4kusula0z1rQioI7iODpbO+Z5Czf8ycBoNKILrr9+Mx7u5fnXS2RmEq3nBPvROhr4VwbNyBJxrsA9RDTLuKUSVAPykAUVwjmNFNLo6xddzhPmvBnzer/pcMx0qgso5AuoIMjSnCFQ5gxD20L8iWJyAftex6GcrAlUTGWsECvOCfa+9Ro5gkzXnOYKDgWDxmf/W/0YrikDVgkxCoA2fwRU9K4L0UXcSCM5bM+P0BOHGYkGf96sogutN2RPqCJwEgjOYKoXICMBBGlAEBz0sDwT6evR44XGVVqpas1EIjPsIpHBe1/623+4lRly11efcVVt3zr3nCI7XEfSnCFT/bSVwtzvQA2df6r6+NbgzR1DJ1HxPoYM2K/52Pk05/C7D50TZE+oInHx9WIXIE4RwDv0rgiP4UQT63lNIai10fa+91vu3BtQRXIeTZZc9heBsUAQ5bo/fqrOMwPtsUnerk09TfSuCyjmC7usI9pG8vVcRsKcQXEYDiuDGz8Bdq5Pq+p5Cdb26Xe+sgiIo5Fk5ggfuR8CeQnA9DSiCcxwr4uLVScc9hX7kBR2uTj5NOdQpPifKnlBHcIQrFcGUEQicOwiXgyLIcZkimDICJccNOFydHK69Ro5gkzXnOYJuAsH3t5hlBNABcBMoghynxm81E5lOIt70nYK71cmnqb4VAXUEV3B2HYHO9xSiXhDupgFF0F8dwbinUJB9eUGHqxM5govt2NNyBJ3VESh7CoFLGlAE5zhWRN3VaZ4ROGLY4erk05RDneJzoow6gjz1/vzsKQSuQRHkqDI7FfcUquhVRTvmcu01cgSbrDnPEbQeCP7tKVTFJ4ATQBGskPF4i5FpTyFV9bhm+rxfRRFcb8qoI8ize67JCEBbNKAI2qojkLU9haz31cmh3jHmfJM15zmCtuoI2GUYGqUBRXCOY0WUz45m9xSy3lcnn6Yc6hSfE2XUEeQpnGv2FILWQRHk+Dk7Ou4pJD/zgn0rAodrrzHnm6w5zxF4DgQiOj5BSEYAGgdFsELG44lXRqA0L+hwzfR5v4oiuN6UUUeQZ3WulT2FoDsaUAR+6gjSs0NpH4FNewpZ76uTQ71jzPkma85zBNXrCApPQxbVKBqiTBOk055CUufZIQA/NKAIKnoz/xnYkGMEqKk7wKGIDFKlPkuw3veuu/VyacphzrF50TZ0+oISgKBiI4PC73OIA4hxQX2FIJuQREsCVFSFmCI01MDMhwuFepbEThce40532TNeY7glkAwCoHXgwNDkJAOHgHol4oftE/aUwTy+l5gyhGEKCFKRTcAnkZ7OQJLDxGmvEC9KFAx4tYy5dCl7k05dOka3NURlHx9qOkJghBTOGhpvgFc4q6O4C4cLgUOXerelEOXrsFXjgAAbsFXjuBGHC4FDl3q3pRDl64BRQAAzuoIAOAWUAQAQI4AABzWEQDA9VBHAADkCACAHAEAGIoAAIw6AgAwFAEAGDkCADDqCADAqCMAACNHAABGjgAADEUAAEYdAQAYigAAjBwBABh1BABg1BEAgJEjAAAjRwAAhiIAAKOOAAAMRQAARo4AAMwsRjleR0AhAUDDqOrRHIGqxijnuAcAV7BIEOwJBGYmIugCgOZIn/nwEQV2BgJ76YIYY4wxxDf06dN33v8ZBTYEgim6AEAH7A8ExAKAPjikCAgEAB2w+tHeFggAoEsIBABAIAAAAgEAGIEAAIxAAABGIACAYRgIBACAIgAAsz/3k1HayQ57AQAAAABJRU5ErkJggg==

your help greatly appriciated

Rgds

Nuwan