Charted data of one data set doesn't match corresponding x-axis value

We grow potted plants and have minimum and maximum height specs that they need to finish within by the time of sale.

We take weekly measurements and get an average weekly height for each crop. The growth rate over time may vary with the variety of plant, so we have three different growth curves (Standard, Late, Linear) that we can compare the weekly measurements to.


I built a dynamic line chart where you can select the crop name and the growth curve from drop-down menus, and it will update to show the target minimum and maximum heights that the measurements should fall within over time and also shows the actual measured height. One other variable is that the Sell Week may change for a variety of reasons, so the chart needs to update if the weeks change from 44 to 46 or from 44 to 43.

These are the issues I would like to fix:

1) I would like the x-axis which, shows the calendar week numbers, to start at the Start Week and end at the Sell Week and show consecutive weekly increments (i.e. 35,36,37,38...). Currently, I am using the curve table week numbers as the x-axis, and they show as decimal points. I tried formatting them as rounded numbers, but sometimes they would skip a week number.
ChartScreenshot.png
2) I want the min and max heights from the curve table and the measured heights to align appropriately relative to the week # on the x-axis. You can see in the screen shot of my sample chart that the measured height of 8.67 (highlighted in red) from Week 37 is plotted on Week 38 of the chart. In my actual chart, sometimes the measured data plots earlier than the actual week when the measurement was taken.

Here is a link to my sample worksheet (https://1drv.ms/x/s!Ane3gAILAlal4hty...48rx4?e=UvbbNh).
The Plan tab lists the crop names, start and sell weeks and the min and maximum end heights for the different pot sizes. The sell weeks can be updated on this tab.

Thank you!

That seemed to work, thank you! I added a Chart_CropREVISED tab to the sample worksheet to show that.

I do also have a question about making the start values for the x-axis and y-axis dynamic to start at start values in the table instead of at zero without manually updating the axis boundary in the formatting menu. Currently, I have lower bound values set to 5 inches for the y-axis and 32 for the x-axis. But if the starting height is 7" and the start week is week 36, I would prefer the graphs to start at those values on the axes.