Hello!
I am working with the free version of amCharts, and I am trying to plot a line graph according to date. My database contains the following entries:
But my chart comes out like this:
where the red represents the total number of searches each day for the search type “City and State” and purple represents that of the search type “Zip Code”.
Right off the bat, you can tell the data is being very incorrectly represented on the chart because the plots don’t even span all the way across each date. So clearly, the points aren’t being lined up to their respective dates. Another problem is (and I’m not sure if this is obvious on the screen shot) there are two red points above “Aug 02”, when that is clearly not the case in the data table.
Does anyone know how I might be able to fix this? Any advice would be greatly appreciated.
Thanks!