Labels "on top" og the graph does not dissapear when I delete datapoints along the x-axis

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

Originally Posted by teylyn

Hello,

that is a very unfortunate data layout for any chart. Try to build a data table where you can select a series as one contiguous range, rather than having to select two ranges in two different columns. That is the cause of the confusion.

For charting purposes, build a table that has the products in rows, and the dates in the column headers. Then each data series will be a single, simple range within a row.

That way you can easily define the time frame that you want to show in the chart.

If you also want a table that illustrates to the reader the difference between last year and the current year, by all means, build this table as a report, but do not try to use that report structure as the source data for your chart.

Keep it simple.

You may need to duplicate some data, but you will save a lot of headache.

cheers, teylyn

Thanks a lot