syoung Report post Posted February 20, 2014 I am having a problem with a chart recognising dates from Excel correctly. I have a simple table in a spreadsheet which is published to SharePoint Excel Services. The table has two columns, the first are dates and the second numbers. I have selected the Excel file, sheet and table cells range in the Collabion Wizard and when I click View Data it shows the data from Excel incorrectly. In the Excel file the dates are in the format dd/MM/yyyy and are displayed as MMM-yy eg. 01/11/2012 => Nov-12 but in the View Data panel of the Wizard the same date is showing as 2014-11-12T00:00:00 How can I get Collabion to recognise the correct dates? Also, assuming the correct dates are shown how can I get the x-axis labels to show MMM-yy? I am using version v1.1.8 on SharePoint 2010 Enterprise. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted February 20, 2014 Hi, We are looking into the issue, will update you soon. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted February 27, 2014 Hi, We have released the fixed version v1.1.9.0, please download it and check. And you can set datetime format as "MMM-yy" by going to "Series Customization" > "Date Display Format". Share this post Link to post Share on other sites
syoung Report post Posted February 27, 2014 Hi, Thanks I will try this out. Does it also fix the issue with the wrong date showing in View Data? Also, stupid question but how do I download the latest version? The site only seems to have a form for downloading a trial version? Thanks Share this post Link to post Share on other sites
Rahul Kumar Report post Posted February 27, 2014 Yes, that fix is also there. And you have to download the same old way but the package you download will have the updated version. Share this post Link to post Share on other sites
syoung Report post Posted March 2, 2014 Hi, The data is now coming through ok thanks but I don't see the date format MMM-yy in "Series Customization", see attached. Thanks Share this post Link to post Share on other sites
Rahul Kumar Report post Posted March 2, 2014 Hi, Could you please clear the browser cache and try again? Share this post Link to post Share on other sites
syoung Report post Posted March 3, 2014 Sorry, I should have tried that first. It's working now. Thanks for the quick response, much appreciated. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted March 3, 2014 You are welcome. Share this post Link to post Share on other sites
DawnCortez Report post Posted September 8, 2015 nice one. Thank you Share this post Link to post Share on other sites
