Forum Discussion
Chaplain Visits Per Shift
Greetings, I need a formula that extracts from column F, Visits to Patients Per Shift, and represent that result in a pie chart and a bar graph. Column F describes the date and time of each Chapl...
It does. I'm on an iMac at the moment, on the Ventura OS -- another update I'd recommend.
My Mac will not update to Ventura OS. I'm using MacBook Pro / macOS Monterey version 12.6.5.
Well, then, I am not sure. I'd be surprised if it doesn't still work. I also have an old MacBook Air, and Microsoft 365 does work on it. Even works on my iPad.
In any event, I've updated that initial attempt to report by month. Here's what the summary looks like. File attached.
Formulae are still less than fully elegant. I suspect SUMPRODUCT might be the more elegant solution, but I've never been able to fully figure that one out. This could be my opportunity.
Actually, come to think of it, with the data revised as I've done it, a Pivot Table would be all you'd need--no formulas at all, except in the derivation of the shift number--and a graph can easily be derived from that.