I have a graph which have a y-axis which is dependent of a table i have made and the x-axis is dependent on a vector of dates.


I have attached an example demonstrating my problem:

TEST_GRAPHICAL REPRESENTATION.xlsx

When I delete the latest or several of the latest dates in the yellow date-vector (because i do not want the graph to display data from these dates) the graph shortens as I want it to but the labels from the part of the graph which is now gone is located at the left of the graph!! How can i prevent this

Thanks