Rather than visually clog up a worksheet with multiple charts, is it possible for one chart to reflect different sets of data depending on the selection made from a Data Validation cell?
In the attached workbook "Varroa 2.xlsx" Im trying to show the different temperature bands that each of the chemicals may be safely used in, compared to the actual day by day temperatures recorded. In these charts provided (one for Formic Pro, the other ApiGuard), they share the same common Dates and Actual Max & Min temps, but differ with regards to the safe temp bands. Formic Pro uses Columns D:E whilst APiGuard uses F:G.
In the end there may be 6 or 7 Chemicals with different safe operating bands, so rather than 6 or 7 charts can it be combined into one super chart depending on the selection?