Forum Discussion
Solved
Line chart, value sorted
Hi together, i have the following data in excel: (with a lot more entrys) In table content like this: Date 0,063 0,125 0,25 0,5 1 2 2,8 4 23.08.2019 7,46 8,47 11,16 2...
see attached. I unpivoted the data in power query.
are you able to share some sample data in text form?
Yes:
| Datum | 0,063 | 0,125 | 0,25 | 0,5 | 1 | 2 | 2,8 | 4 | 8 | 11,2 |
| 23.08.2019 | 7,46 | 8,47 | 11,16 | 21,14 | 52,89 | 93,00 | 100,00 | 100,00 | 100,00 | 100,00 |
| 06.09.2019 | 5,39 | 6,30 | 8,02 | 14,36 | 34,69 | 89,31 | 100,10 | 100,10 | 100,00 | 100,00 |
| 13.09.2019 | 6,77 | 8,28 | 12,13 | 27,14 | 54,90 | 94,90 | 100,27 | 100,27 | 100,00 | 100,00 |
| 20.09.2019 | 11,35 | 13,43 | 17,23 | 29,75 | 51,60 | 93,40 | 100,34 | 100,34 | 100,00 | 100,00 |
Is this ok?
see attached. I unpivoted the data in power query.
Thnaks i also tried this. But i dont get it like this in Exel
The y-axis ist from 0-100% and on the x-axis there should be the name of the columns.
Thanks for your patience
is this how you want the data?