I am not so sure this is possible and I have trawled over various videos and guides from various posts on range charts in 2008R2 e.g. pnarayanaswamy blog
I have data that shows start and stop times for a machine (truck) on a given day, for the last 30 days. I am trying to show days of operation on the vertical Axis (last 30 days) and the horizontal axis to display various ranges inside a given day illustrating the duration of start and stop times.
Is this possible?
See attached image of potential end result except it would span 30 days not just one.
I cannot seem to add a picture but a bit more information:
Task/Date start end
==== ====== ====
2013-11-06 2013-11-06 07:00:00.000 2013-11-06 07:50:00.000
2013-11-06 2013-11-06 07:50:00.000 2013-11-06 08:20:00.000
2013-11-06 2013-11-06 08:20:00.000 2013-11-06 09:10:00.000
2013-11-06 2013-11-06 09:10:00.000 2013-11-06 09:40:00.000
2013-11-06 2013-11-06 09:40:00.000 2013-11-06 10:20:00.000
2013-11-06 2013-11-06 10:20:00.000 2013-11-06 11:10:00.000
I added start for TopValue, end for bottomvalue and task for categories. I tried everything that is in this blog like enable variable interval, draw side by side etc. but nothing resolved my problem.
I am getting a graph like
07:00 08:00 09:00 10:00 11:00 12:00
Thank you for your question.
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.
Thank you for your understanding and support.
TechNet Community Support
can you upload your picture (how you want it to be and how it comes right now) to a image hosting site like ImageShack.com and paste the url here?
Jason | www.SqlJason.com
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Can you provide us an image as to how you expect the graph to appear? Also does the data for each row would contain the only 3 columns as shown in the post or will it contain more columns?
What is being plotted as values in the chart? Is there some column that carries truck number / any info?
Please help me answered with the above questions and information.