Forum Discussion
Excel Gantt chart
AlexFun2245 Maybe you have direct question which could be answered without watching the video?
SergeiBaklan 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.
SergeiBaklan 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.
