Line charts: 1. Including no data? 2. Customize colors?

[JillClogston]

Hi all,

1. I am creating a line chart of whale sightings with year on the x axis and counts of sightings on the y axis. Each graphed line represents the number of sightings for a unique geographic location. Some geographic locations have sightings in one year but maybe none the next. How can I include a data point of zero for those years without sightings?

2. Is there a way to select standard colors for the graph, similar to how we select them for symbology - from a drop-down list? In the Chart Properties window, it looks like I have to select each line and define it, one by one?

Thank you!
Jill 

[ChristopherAllen · Accepted solution]

Hi @JillClogston ,

Thanks for the questions!

1) Temporal line charts that aggregate by count should automatically fill in missing data points with zero. Based on your description, I'm assuming your x-axis field is an integer rather than a date. In this case, I'd suggest using an Arcade expression to convert your integer "year" field into a date. You would do this by clicking the "Set an expression" button to the right of the Date or Number dropdown:

And then you would use the Date function to construct a date field, passing the "year" field as the year and using January 1st as the month and day:

2) There is not currently a way to apply a color palette to chart series, but we hope to implement this in a future release!

Please reach out if you have further questions!

Thanks,
Chris

[JillClogston]

Thank you very much Chris!