I looked at different flash chart software (free and commercial) and could find only one that supports the feature I want: map my dataset on the predefined X axis. Let me give an example.
Let s say my X axis is time. The time is represented in hours. So let s assume my X axis has last 24 hours. Now the data I have in the database contains data coming every 50 minutes. My goal is to have a chart that will show this data. The point on the graph will not correspond to X axis values one to one.
The simple solution (and all charts support this) is to set X axis resolution to 1 minute and only show "ticks" on A axis every hour. Assuming that chart supports "null" values (and most of them are) - it works fine as an idea.
The problem is that in this case (for all of the charts I know) I have to provide XML/json/CSV as a source of data that will contain 24 hours * 60 minutes points of data, with only ~29 (24 hours, every 50min) containing meaningful data. This puts a stress on 1) database, 2) more traffic 3) makes chart less responsive.
Are there any flash graphs that will accept a dataset of ~29 values and map into 24 points on X axis.