For the course of Gantt chart, https://www.youtube.com/watch?v=HfAOkXt5V_8, I have a question about how to determine the value of "Y-axis for Plan", because the value will affect the gap distances between the plan line and actual line as the value changing.
May somebody help me how to ascertain the value of "Y-axis for Plan" while you're free?
@Sergei Baklan Hello, Sergei, thank you for your response. I paste a Excel table, I just want to know how to determine the values of "Y-axis for Plan", this is a challenge because this value will affect the blue lines' position. Thank you for your help.
Blue lines is scatter with errors bar which is linked to secondary Y axis. Values for the axis are in column Q which is simply sequential number of tasks from 0 to 8 shifted up on 0.2 for better visualization. Secondary Y axis is formatted with max 9, min 0 with major step as 1 (thus each major tick is against the task name) and minor step 0.2 which positions blue line bit higher.
Thus that's nothing more than numbers 0..8 plus 0.2.
@Sergei Baklan Hello, Sergei, I attached my file again, I confused about the value for Y-axis for Plan, because the blue line can't match every items and just locate below of the items accordingly. Thank you very much for your help.
