Hello,
I am trying to create chart with text labels on X axis. I know about categorical chart, but in my case this is not an option and I'll tell why.
Each of my items has Count filed, CustomDate field and Label field. Count is used for Y axis. CustomDate is integer value and it is used on X axis. Label field is a string that is generated based on CustomDate and I want it to be displayed on X axis ticks, not CustomDate values. I cannot use XCategory to bind to X axis because chart can calculate difference between CustomDate values, i.e. it knows that there is difference of 5 between 5 and 10. But if use XCategory and string field it cannot calculate difference between for example "5" and "10". But this gap between values on X axis is very important.
So, is there is any possibility to use integer values on X axis using XValue, but to display string labels not these integer numbers?
I am trying to create chart with text labels on X axis. I know about categorical chart, but in my case this is not an option and I'll tell why.
Each of my items has Count filed, CustomDate field and Label field. Count is used for Y axis. CustomDate is integer value and it is used on X axis. Label field is a string that is generated based on CustomDate and I want it to be displayed on X axis ticks, not CustomDate values. I cannot use XCategory to bind to X axis because chart can calculate difference between CustomDate values, i.e. it knows that there is difference of 5 between 5 and 10. But if use XCategory and string field it cannot calculate difference between for example "5" and "10". But this gap between values on X axis is very important.
So, is there is any possibility to use integer values on X axis using XValue, but to display string labels not these integer numbers?