On the GrowthChart tab of my workbook, I want to include a dynamic scatter chart that plots actual measurements of weekly plant height measurements against two different growth curve min and max measurements depending on which is selected. These are some goals for the chart:
1) Have the chart dynamically update to show the Min Ht and Max Ht for the Late Curve or the Standard Curve depending on which is selected in the drop-down menu above (The data for these is in two tables on the GrowthChartData tab)
2) On the chart, omit the Avg Ht data points where there is no data
3) Dynamically format the chart so that the start point on the X-axis is the first calendar week number from B8 (highlighted blue) and so the start point on the Y-axis is the first Avg Ht number from C8 (highlighted green). Note that the C8 is a named cell 'PinchHt'. I know that I can manually enter the upper and lower bounds for charts, but I want this to update automatically depending on the start values of the actual crop which may vary by several inches or several weeks from crop to crop.
As mentioned above, the data for the Standard Curve and Late Curve are in two tables on the GrowthChartData tab. I am not sure if these may need to be combined into one table. The current curve data shown in the chart is from the Late Curve table.
Sample file: CopyPlantMeasurements2023-V5.xlsx
Bookmarks