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
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”:
Thank you! That worked
It looks like you're new here. Sign in or register to get started.