Charting by Date
Thanks for the help. Any suggestions are appreciated!
I have a View in my SQL Database that contains the data for the chart. I can sort the data by Date. I can use the wizard to create the Recordset and have done that. I have created other charts using your product (Pie Charts) with success.
I have had success charting the data using Excel but really need to make this work using your product so that I can have the charts be dynamic for our Managers accessing the charts on our company intranet. I can do this using Excel but it is cumbersome to post to a website and the data is not dynamic for users offsite not on our network.
It doesn't appear that I can create Bar charts where the bars are horizontal, that is not a problem. I can just reverse the data for the axis. Using vertical bars, I would need the Date field to be the y axis (grouped by Week, etc) and the Task (varchar) field to be the x axis showing across the bottom of the chart. The bars would show vertically when the funding for the Task runs out. Then I'm hoping I can create a similiar chart showing vertically the Tasks across the bottom showing when the Tasks Expire. I will then try to combine the 2 charts (using your directions) to have an effect like the one I create in Excel. The chart shows the Tasks and vertically would show the difference between when their hours funded will run out compared to when the Tasks expire.
Again, thanks for the help! I use several webassist products.