Would like this graph to have time along the x axis rather than duration - how?

• jameslester78

  Mr or Mrs. 500

  Points: 526

  More actions

  February 19, 2015 at 6:15 am

  #295430

  rdl file: https://db.tt/2aQSE8Qi

  The above report look like this:

  

  along the x axis I have duration in minutes, I would instead like the time of day and for each block in the graph to start at its start time and end at its end time

  For example:

  

  Can anyone suggest how I would do this using reporting services by modifying my existing report

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  February 19, 2015 at 6:36 am

  #1778621

  It's a bit like a Gantt chart, but with multiple events at one row.

  Someone had a similar question like you, and it seems he found the answer:

  https://ask.sqlservercentral.com/questions/95761/gantt-range-chart-with-multiple-events-per-row.html

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP