Hi Jeffrey,

You have to use either Mesh or Triangulated surface (e.g. surface that accepts x / z values from the Data groupings editor). You can change the surface type from the surface sub type combo. You get 01/01/1899, because this is actually the value 0 translated to date time - in other words when you use the Grid surface it will have categorical values (0, 1, 2, etc.) and you cannot use a date time axis for these x/z values in a meaningful manner. You can take a look at the Mesh surface example which imports values for the XYZ values of each data point.

Hope I helped - let me know if you have any questions or meet any problems.

Best regards,
Bob

Hi,

I am having a similar problem.  I require a line chart with a secondary Y axis to display 2 separate lines over time.  My query returns 3 columns (ValueA, ValueB, ValueDate) for a year. In 'Chart Properties', I am grouping by ValueDate - in the Categories second.

When viewing the results, the lines and Y axis appear correct, however, the X axis starts at 12/30/1899. 

Thanks for your help

Hi Jennifer,

You have to switch the lines in XY scatter mode (from the chart type tab select line and then from the subtype combo on the right select XY scatter). Then go to Data and double click on the values - this will show the “value groupings editor” - you'll notice that it now allows you to enter a X value - this is where you should assign the date time column.

The general idea is that value / date-time pairs represent scatter charts as both the x and y coordinates can be irregularly spaced (as opposed to ordinal charts, where only the y values vary and the x values are equally spaced - like the standard bar chart), therefore you have to additionally provide an X value in date time format before assigning a date time axis.

Hope this helps - questions or comments - please feel free...

Hi,

I also have the Same problem and When I use XY Scatter with eSUm of Y axis verses Date on Xaxis is giving the same problrm.When I try your solution in Data part the X-axis dropdown is giving values as count(Datetime).Is there anything I have to modify.

I am struck for the past 4 days.Any help is appreciated!

Hi Prabaharaprabu,

You can use "=First(Fields!SomeDateColumn.Value)" - its not mandatory to use the default expression...

I tried the Same and it is giving the result as 1898 is the starting date and ending 1900 and the $ value column as 0..0..0...1..1..1

What is causing the problerm.I am using XY Scatter chart.If I use Series then the X axis is taking all the values from the table and the chart is about 5 pages.

Kindly advise.

Prabu