Ghantt char in SSRS not displaying all the categories

• sql server developer

  SSCarpal Tunnel

  Points: 4746

  More actions

  March 26, 2012 at 10:43 am

  #253181

  Hi,

  I've created a Ghantt chart in SSRS 2008 by following this wonderful blog by Narayana. I've a report that has 21 categories but the chart is showing only 4 of them on the Vertical axis. However, I could see 21 bars on the chart. I wonder if the report is hiding the categories. I appreciate if someone could help!

  http://pnarayanaswamy.blogspot.com/2010/09/range-bar-chart-gantt-chart-using-ssrs.html?showComment=1332779527205#c7843380050487800074

• sql server developer

  SSCarpal Tunnel

  Points: 4746

  More actions

  March 27, 2012 at 5:35 pm

  #1465416

  I was able to figure out the issue.

  In SQL Server 2008:

  Right Click on the Y-Axis --> Select Axis Properties -> Select "Enable variable interval"

  In SQL Server 2008 R2:

  Select Y-Axis --> In the properties SET VariableAutoInterval to "True"