How to evenly space a chart x-axis by Date?
Posted: Wed Jun 19, 2013 7:46 pm
So I have a Line Chart that displays a numeric value for each date, or a sum for the month. Is there a way to get the chart to put spacing between data points such that each day has exactly the same width, even if it is not a data point?
Alternatively, is there a way to prevent a point on the chart from being generated at zero for data that has a date but no value? (I tried Show Null = False and Convert Null = false, no luck). I looked at this thread: http://forum.stimulsoft.com/viewtopic.p ... =10#p67656 for help on this method but it still doesn't work.
EDIT:
I've attached a report with two simple charts. Basically, in the first chart ("Null value") I would like the NULL value to not display a data point, so the line goes directly from x=3 to x=5. The '0' value (x=6) should still display, and the chart should still show 4 on the x-axis. It seems to be shifting all values left, so that everything to the right of x=4 has wrong y values.
In the second chart ("Even Spacing") I want x=5 to show on the x-axis, even though there is no data point; the line should not have a point there and go straight from x=4 to x=6.
I've also included a chart that is identical to the Even Spacing chart, but uses datetime arguments instead. Like above, I want may 4 to show on the x-axis, but no corresponding data point in the graph
I don't necessarily need all of these, but I do need at least one of them; I can get the data to work out with any one of them.
Alternatively, is there a way to prevent a point on the chart from being generated at zero for data that has a date but no value? (I tried Show Null = False and Convert Null = false, no luck). I looked at this thread: http://forum.stimulsoft.com/viewtopic.p ... =10#p67656 for help on this method but it still doesn't work.
EDIT:
I've attached a report with two simple charts. Basically, in the first chart ("Null value") I would like the NULL value to not display a data point, so the line goes directly from x=3 to x=5. The '0' value (x=6) should still display, and the chart should still show 4 on the x-axis. It seems to be shifting all values left, so that everything to the right of x=4 has wrong y values.
In the second chart ("Even Spacing") I want x=5 to show on the x-axis, even though there is no data point; the line should not have a point there and go straight from x=4 to x=6.
I've also included a chart that is identical to the Even Spacing chart, but uses datetime arguments instead. Like above, I want may 4 to show on the x-axis, but no corresponding data point in the graph
I don't necessarily need all of these, but I do need at least one of them; I can get the data to work out with any one of them.