In the Workbook attached, I am currently plotting recorded Min & Max temperatures on a chart. This is working, however I'd like to extend the capabilities of the charting tool to be able to define the period of data to be charted. Options being selected with the data validation value in cell G34. Can someone please show me how this is possible? Please note that there is currently data in columns D & E ( written in white font to enable clarity when reading the physical temperature data - it defines the safe temperature range for the use of a particular chemical that may be applied to bees, as indicated by the light brownish colour in the chart).
The second objective will be in another thread.