Displaying Month In Scroll Charts

[Displaying Month In Scroll Charts]

Hi,

 

I created a chart with Chart Type "Scroll Column 2D". Data provider is a SP List. The chart displays 2 series for the colums and goes over several months. I'cant display the months anywehre on the scroll chart. So, by scrolling users can't see wich month is now displayed. Please see Attachements.

 

Thanks for Support

[Order On X-Axis In Drilldown (Collabion Chart)]

Hi,

 

What I mean is if type of column is not datetime, the code will not be able to identify whether the data inside that column is datetime value or plain text value. And even if we forcefully check and convert words like 'Jan', 'Feb', 'Mar' etc to datetime fields there'll be still issues which can arise such as:

1. Conflict with the Month name e.g. 'Jan' or 'January'

2. Things will be more complicated if data contains month text in different language other then English.

 

Hi,

 

I understand, Thanks for your help.

 

Best regards

[Order On X-Axis In Drilldown (Collabion Chart)]

Hi,

 

Thanks for the information.

 

We have checked the scenario but I am afraid, it would only if the column type is Date and Time.

 

Hi,

 

Sorry for delay !

 

I don't understand, if column type is Date and Time I can't type in a month ?

 

Best regards

[Order On X-Axis In Drilldown (Collabion Chart)]

Hi,

 

I am afraid, you missed to attach the screen shot.

 

Regarding the issue, could you please make sure that the column type for Month field is of DateTime Data Type? And could you please also post the screen shot of the wizard after moving to "Select Fields" step and highlighting the columns which you use for Grouping and Drill-Down?

 

Hi,

 

column type for month is "Choice" , and the 12 monthes are listed in the Choice-Window. If the column Type is DateTime users can't enter a month ? I attached the differents screenshots. ?I'm working in a german country, so: "Monat" = Month . Thanks for helping me !

[Order On X-Axis In Drilldown (Collabion Chart)]

I DrillDown a MainChart in months, but the order in wich months appear on X-Axis isn't correct. Data Provider for the Chart is a SharePoint List. Please see screenshot at attachement. Thxs for help ...