CODEWITHSUNDEEP
excelgraphplotchartslinechart
beta
beta

Reputation: 5686

stretch line chart to same length in excel

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.

Upvotes: 0

Views: 1387

Answers (1)

marmarta
marmarta

Reputation: 838

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

Upvotes: 1

Related Questions