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