Forum Discussion
How to standardize x-axis units from real data in a line graph or scatter plot?
I am trying to chart a variable (called RR) against a real number of years and create a chart like the one below. Unfortunately, I had to capture the inputs by setting the RR variable in a model and ...
Hi Kate,
To show your x-axis in years with 1 year increment better to transform your x-values into dates with helper column, like
=DATE(INT(C19)+100,1,MOD(C19,1)*(DATE(INT(C19)+1,1,1)-DATE(INT(C19),1,1)))
After that use Yrs instead of time as your x-axis and format it as
with YY format
Result is like this
and attached
Thank you!! Using a date conversion had occurred to me, but I was too fried to work it out. REALLY appreciate this!!