I am struggling to sort information in my graph. Easily said, i would like to use the excel function "Custom sort" to be able to sort:
1. with date ascending
2. with time ascending
I added some data in the excel attached and the graph I would like to display.
The major idea is to display material changes in the production. Each color is a material change on a given day on the produciton line.
The graph shows the dates on the horizontal axis correctly.
Unfortunately it doesnt follow the "hours timing" from each day.
What I would like is that the graph displays each material changes on its day with "time start" ascending (from starting time in the morning to evening).
