Forum Discussion
Solved
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...
I found a solution using PowerQuery and a Pivot Table. The solution is in the attached file for whoever may find it interesting.
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,
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.