To set range in overlay

[#1]

I have a data and I want to see scatter plot trend overlay by year. Ive created a year formula, but after I drag it to overlay, it creates a default 5 years range. How can I define my own range when I overlay the trend?

[#2]

Can you show us the feature you are looking for in a screen shot?
There is a difference if the column used in overlay is ordinal or continuous

mlo1_0-1619476064201.png

mlo1_1-1619476114069.png

[#3]

It’s continuous and rather than having it range from 2000-2005, but I want to see every year data ->2000, 2001, 2002, etc

[#4]

It would be my suggestion to create a new column that assigns the ranges to specific bin values, and then use that column as the overlay column.

[#5]

Please could you elaborate further how to formulate that in a column? Thank you 

[#6 · Accepted solution]

Just create a new column, in my example I call it Year Bin.  Use the formula:

If(
	:Year < 2010, "2005-2009",
	:Year < 2015, "2010-2014",
	:Year < 2020, "2015-2019",
	:Year < 2025, "2020-2025"
)

yb1.PNG

Which yields the following graph with the year bins as defined in the formula

yb2.PNG

[#7]

Thank you very much!