0
votes

I have two series with data points in excel.

The data looks like this:

enter image description here

If I create a simple line chart it looks like this:

enter image description here

However, I would need the red line to be of the same length as the blue line since the data of both series stretches over the same time. Unfortunately I dont have the timestamps of each data point. But I guess there must be another way to do this.

It should be something like stretch the line over the whole x-axis of the graph.

1

1 Answers

1
votes

If you have start and end timestamps for both, you can fill empty places with =#N/A

That is, the not available error.

If you do not have the end/start timestamps for either, you will need to calculate them yourself.

Picture:

enter image description here