How to add date to x axis on line or time line chart

[Sarah Killeen]

When creating a line or time line graph using the Chart from Table macro I cannot get the date field to display on the x axis.  It has something to do with the date format but i can't get the format to change.  I've taken a screenshot of my data and the date format error

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Sarah Killeen,

The issue is not only in the date format but you have the values columns messed up as well. Please go to the page edit mode and enter the Chart from Table macrobrowser:

Check the Adjustments tab and make sure that you have the appropriate date format “dd-mm-y” and that your table data orientation is set to “Horizontal”:

[Sarah Killeen]

Thank you! That worked