Data labels not displayed correctly

I am attaching my workbook

QA Series : Difference between two columns ( QA Start and QA End)

MFG Series: Difference between two columns ( MFG Start and MFG End)

LGS Series : Difference between two columns (LGS Start and MFG End)


1) If there are values only for the GO SALE column, the values getting displayed only at the front irrespective of choosing INSIDE BASE. I need to forcefully move the labels by entering a dummy date in the other columns.

I need to go everytime and click the labels and edit the date I want to display the range of dates.

2) LGS Series: If the MFG End and LGS Start - For example: For the Row 1, it ends at 11 July 2019 and GO SALE 2 DATE displays immediately after 11 JULY 2019 instead of it displayed at 16 JULY 2019

3) I need to display range of date values in the labels in the chart.

What I did: Initially all the cells in the SALE column were set to DATE. Now, I format SALE Column, to be of Text / General, include the range of date values, set the primary primary horizontal axis and secondary axis to be of TEXT / GENERAL but when I update the graph with new data, I need to change the columns to date format with a single date entry and thereby need to change the axis to DATE as well.