Hello,
I've tried for some time now to create a chart where the x-axis make up for irregular dates. Making the line between 2 points longer if it's long time between them and short if it's short time between them.
I've finally understood line charts doesn't support that and I have to use scatter graph.
It seems to work but the dates, the get all messed up. I type 2014-11-11 but the x-axis in the graph shows 2283-12-12 or something like that.
I've googled and googled but can't see to find a solution. Got a notion that I might have to transform it to the date value manually first but I get #VALUE ERROR (roughly translated, not english office unfortunately). I.e. 2014-11-11 in A1, then I type in A2 =DATEVALUE(A1).
So main question is how do I get a chart to work with irregular dates correctly?
Thank you.
I've tried for some time now to create a chart where the x-axis make up for irregular dates. Making the line between 2 points longer if it's long time between them and short if it's short time between them.
I've finally understood line charts doesn't support that and I have to use scatter graph.
It seems to work but the dates, the get all messed up. I type 2014-11-11 but the x-axis in the graph shows 2283-12-12 or something like that.
I've googled and googled but can't see to find a solution. Got a notion that I might have to transform it to the date value manually first but I get #VALUE ERROR (roughly translated, not english office unfortunately). I.e. 2014-11-11 in A1, then I type in A2 =DATEVALUE(A1).
So main question is how do I get a chart to work with irregular dates correctly?
Thank you.