Sep 12 2020 09:47 PM
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?
Thanks in advance!
Sep 13 2020 05:50 AM
@AlexFun2245 Maybe you have direct question which could be answered without watching the video?
Sep 13 2020 11:54 PM
@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.
Sep 14 2020 02:32 AM
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.
Sep 14 2020 05:13 PM
Sep 14 2020 05:48 PM
@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.
Sep 15 2020 04:18 PM
You shall manually define options for the secondary vertical axis
min = 0
max = # of items+1
and units accordingly
Sep 16 2020 01:22 AM
Thank you very much, Sergei. It's very helpful. Thank you for your quick response and kindness.