Hi everyone,
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).
Hope it is clear enough...
thanks a lot for your help
Mat