How to evenly space a chart x-axis by Date?

Stimulsoft Reports.WEB discussion
Post Reply
Morgan
Posts: 11
Joined: Wed Jun 05, 2013 3:52 pm

How to evenly space a chart x-axis by Date?

Post by Morgan »

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.
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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to evenly space a chart x-axis by Date?

Post by HighAley »

Hello.

Please, try to use Scatter Line Series.
Look at the attached report template.
Report.mrt
(15.94 KiB) Downloaded 493 times
Thank you.
Morgan
Posts: 11
Joined: Wed Jun 05, 2013 3:52 pm

Re: How to evenly space a chart x-axis by Date?

Post by Morgan »

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.
Andrew
Posts: 4109
Joined: Fri Jun 09, 2006 3:58 am

Re: How to evenly space a chart x-axis by Date?

Post by Andrew »

Hello,

Have a great weekend!

Thank you.
Post Reply