Forum Discussion
auto adjusting axis based on cell ranges
Hello! I have this cluster stacked bar graph that shows infectious period over a course of time, this graph will auto populate as the data is entered over time, the patient names axis pulls from a ...
Thanks. It was a bit more complicated than I thought, but here is the modified version.
You can see the defined names in Formulas > Name Manager.
do you know if theres a way to auto set the minimum and maximum bounds based off the dates, currently I have to manually adjust them so that all periods are shown, when entering new data the axis bounds have to be reset each timeHansVogelaar
In the attached version (a macro-enabled workbook again), I have added code to the worksheet module that dynamically adjusts the minimum of the value axis when the Dashboard sheet is activated.
- thank you! that worked!