I am new to the product and trying to get a datetime axis to render with a label for each day and 4 minor ticks for 6 chunks of time.

When I set the axis to Scale "Numeric" the axis shows up as dates starting with 01/01/1899. I have read through the help and tried many different configurations and can't figure out what I am doing wrong.

Rather then describe my settings I attached my RDL.

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

Best Regards,
Nevron Support Team