MacroEcon1337
Board Regular
- Joined
- Mar 16, 2017
- Messages
- 64
Hello!
I'm wondering if a certain chart can be created in excel. The base data (blue) contains information about bacteria concentration levels for various depth ranges/cohorts/blocks. I have no problem charting the base chart in excel. The problem is, I want to shade a specific region under the curve for a target band in red (see picture).
Example: I want to shade the region between 10,000 and 32,000 feet (in red). The image below shows exactly what I am shooting for (a red overlay between 10,000 and 32,000).
Anyone have an idea for how this chart could be created in excel? Where all i need to do is change the Target Range (shown as 10,000 to 32,000 below) and have the chart dynamically update? All ideas/suggestions are greatly appreciated!
- MC
<tbody>
</tbody>
MC
I'm wondering if a certain chart can be created in excel. The base data (blue) contains information about bacteria concentration levels for various depth ranges/cohorts/blocks. I have no problem charting the base chart in excel. The problem is, I want to shade a specific region under the curve for a target band in red (see picture).
Example: I want to shade the region between 10,000 and 32,000 feet (in red). The image below shows exactly what I am shooting for (a red overlay between 10,000 and 32,000).
Anyone have an idea for how this chart could be created in excel? Where all i need to do is change the Target Range (shown as 10,000 to 32,000 below) and have the chart dynamically update? All ideas/suggestions are greatly appreciated!
- MC
Depth Cohort | Bacteria Concentration | |
<tbody> </tbody> | 300 | |
<tbody> </tbody> | 250 | |
<tbody> </tbody> | 500 | |
<tbody> </tbody> | 550 | |
<tbody> </tbody> | 600 | |
<tbody> </tbody> | 770 | |
<tbody> </tbody> | 900 | |
<tbody> </tbody> | 950 | |
<tbody> </tbody> | 800 | |
<tbody> </tbody> | 1225 | |
<tbody> </tbody> | 1150 | |
<tbody> </tbody> | 1150 | |
<tbody> </tbody> | 1100 |
<tbody>
</tbody>
MC