syoung

Members
  • Content count

    8
  • Joined

  • Last visited

Posts posted by syoung


  1. Hi,

     

    Can you help me with a simple chart I am trying to configure?

     

    I have a small set of data as follows

     

    Schedule As of Jan 2014 Current Forecast Nov-2018 Original Contract Nov-2016

     

    and I need to create a chart as attached. The issue I am having is it doesn't seem to recognise dates as a scale on the y-axis. I can only set value for the y-axis min and max as numbers and the bars do not show.

     

    Is this possible? Any advice would be much appreciated.

    post-62510-0-65629000-1393994214_thumb.png


  2. 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.