Adding Constant line to represent "today" in stacked bar chart

  • Just read one of the great articles entitled "Gantt charting for the holidays" by David Leibowitz. It effectively describes a technique for producing a gantt chart using a stacked bar chart. I wanted to extend this report further by introducing a constant line in the Y-axis to display where "TODAY" is in the Gantt chart.

    I have already tried manipulating the "Minor gridlines interval" on the Y-Axis and this works in some cases where for example "TODAY" is far greater than the start date of any task, but where this is not the case I get a repeated minor gridline interval indicating multiple "TODAY" points on the gantt chart which is clearly wrong.

    I cannot seem to crack this problem. All of the grouping and data series stuff effectively alters the "category" elements of the report in the X-Axis so I am all out of ideas. Any of you bright sparks out there got any clues.

    For those of you who haven't read the article we are dealing with a stacked bar chart here, SSRS and I am using the report viewer control to render an RDLC report (converted from the original RDL in the article).

    Any help would be appreciated!!

    (Also posted this in article discussion thread.)

    Regards,

    Si

  • Well after much deliberation I gave up with the idea of a constant line in the Y axis favouring instead a progress time bar across the top of the report (per page) which is accurate and effectve and changes with each "chart area" on each page which is what I wanted for this particular dataset.

    Thanks anyway.

    Si

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply