Scatter Plots and Date on X-axis

JennaOlson

I am working on Charts in ArcGIS Pro 3.1.1.  I need to use a Scatter Plot so that I can produce a trend line and not have a line connecting all of my data points.  My X-axis needs to be a date, date is not a numeric variable so is unacceptable.  I then created a new table and changed my dates to a number type. The Chart is close to what I need, but I now need an arcade expression or formula that I can use that will allow my numerical date to display as a date.  Example: 33258 needs to display as 1/20/1991 on my axis label.  Or if anyone has any better suggestions, I'm all ears.

 

Thanks!

DanielFox1

Hi @JennaOlson 

You can create a new field in your attribute table and ensure that you set the field to date (see screenshot below) then using calculate field use the following as shown below this will display the numeric date back into a readable date value and you can display the chart of this information. 

Original Date

Add new Field that is Date but has a number format as numeric

(for my example I used the calculate field to ensure a numeric date was placed in this field, referencing the original date) 

 

Create a new field for Date that has no number format 

Using the same method of calculating field I made the new field = the previous field which has a numeric format.

Highlighted below is the converted numeric field to a readable date 

Then you should be able to use the new field on your axis. I hope this has helped.