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 ...
I uploaded the excel file because I got stuck at the defining portion, the two worksheets are titled "person diagram" and "person graph"
I don't see an attachment or a link.
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