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

Sarah Killeen March 28, 2023

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 errordate error.jpg

 

1 answer

1 accepted

3 votes
Answer accepted
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 29, 2023

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:

Wed 1-1.png

Wed 1-2.png

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”:

Wed 1-3.png

Sarah Killeen March 29, 2023

Thank you! That worked

 

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events