Hello,

I’m trying to create a chart in Excel with several straight lines composed with 2 data points each.

Each costumer has a sell date and sell value, and a purchase date and purchase value. Dates are in the X axis.

I just want that for each customer there is a straight line between sell and purchase value, on their respective dates, for each of the customers.

Is it possible?

I’ve attached an example file here.

Thanks in advance.

​Hello, I’m trying to create a chart in Excel with several straight lines composed with 2 data points each. Each costumer has a sell date and sell value, and a purchase date and purchase value. Dates are in the X axis. I just want that for each customer there is a straight line between sell and purchase value, on their respective dates, for each of the customers. Is it possible? I’ve attached an example file here. Thanks in advance.  Read More

​