Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Posted: 18 May 2011 at 8:09am
I am actually doing a line chart per month. They want to see the trend lines across the months. e.g. The first value should be the starting number 3 and then 9, then 11 and 21 in the chart, but thats not happening.
Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Posted: 18 May 2011 at 8:41am
They want the line chart to be set to vertical so that they could see the months on the x-axis (across). Anyways I did all the things you mentioned and also included to see the data value on the line chart but all i see is 20, 21 and 26 on the markers that i have set up. I also plotted the actual count of the structure have and it on the chart to compare the cumulative count and actual count, but the cumulative count is still showing strange values and are not adding up in the chart.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 18 May 2011 at 9:00am
use the RT in your main report to tease out where there are unexpected numbers and look at your data to figure it out. If the RT is wrong the graph will be wrong.
You can set the graph horizontal if needed, jut make sure to make your date field sort orter asc or desc to have it make sense. It naturally is asc which woul make your chart visually appear to descend in value rather than ascend in value.
Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Posted: 18 May 2011 at 9:11am
ok. It looks like the the asc or desc order is affecting how the values are spread out. I think its close now. THANK YOU SO MUCH for all the time you put in helping. God bless You Buddy !
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
