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.
How to evenly space a chart x-axis by Date?
How to evenly space a chart x-axis by Date?
- Attachments
-
- Null Value and Spacing tests.mrt
- New file 6/20/13; original file had a bug with the 'null' entry; included chart with Date argument
- (28.76 KiB) Downloaded 273 times
Re: How to evenly space a chart x-axis by Date?
Hello.
Please, try to use Scatter Line Series.
Look at the attached report template. Thank you.
Please, try to use Scatter Line Series.
Look at the attached report template. Thank you.
Re: How to evenly space a chart x-axis by Date?
Ah. That's pretty easy; I didn't think there would be that much difference between them. Scatter Line is working much better for me.
Re: How to evenly space a chart x-axis by Date?
Hello,
Have a great weekend!
Thank you.
Have a great weekend!
Thank you.