Hey.

I wan´t my chart to + and - my data instead of just putting it in. Example:

In cell A1:A4 I have the dates and in I1:I4 I have the numbers I want to plot in.

I have 2 duplicates of dates btw.

The chart will then start from the 1st number, then straight up in the air till it reaches the 2nd number. Then it makes a "bridge" between the dates up to the 3rd number, and then goes down to the 4th number.

Instead off calculating the two numbers with the same date and then calculate the other two numbers with the same date and then make a straight line between those two points.

Any ideas?

Thank you.