Forum Discussion
Create Excel Chart with multiple series each with 2 data points
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.
I found a solution using PowerQuery and a Pivot Table. The solution is in the attached file for whoever may find it interesting.
5 Replies
I found a solution using PowerQuery and a Pivot Table. The solution is in the attached file for whoever may find it interesting.
Congratulations!
You need an XY Scatter chart for this, based on a different data layout.
In the attached version, I have done this for the first 5 customers.
- Hello, thank you very much for your reply.
I thought about something like that. But there are 2 problems: first, in this format you need to manually create each data series, and second, my data comes from a Pivot Table and as far as I know I'm not able to create the pivot table in this format.
Thank you,As far as I know, it is not possible to create the chart directly from the data in the layout you posted.
