Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

6
  • Thank you for your answer. Attendance is "tracked" over time; that's a given. Day=Daily= Date. I'm not sure how I could have made that more clear, but sorry for the confusion. Also, this chart is not what I'm wanting. I want 9a totals charted + 11a totals charted, but total summary for the day to not include duplicates. If you put the 9+11 column before the 11 only column, it would almost be right, but you would still have to manually sum the "only" and "&" columns to get the correct numbers. I'm trying to do an "overlap", almost like a starting disadvantage for the 11a side of the chart. Commented Apr 30, 2021 at 20:13
  • See my addition, after "EDIT". Commented May 2, 2021 at 0:11
  • this looks exactly like what I'm looking for. I'm going to try it out and let you know if it works. Thanks! Commented May 3, 2021 at 17:03
  • I think putting the overlapping region in the middle makes loads of sense, visually, so you can intuitively include with either of the other area - a bit like the overlapping region of an Euler / Venn diagram. I agree that stacked columns is clearer than an area chart for all the usual reasons, including focussing on heights (values) rather than slopes (rates of change).
    – AdamV
    Commented May 6, 2021 at 14:40
  • @MichaelYaeger - did it work? Will you mark Jon's reply as the answer if it did?
    – AdamV
    Commented May 6, 2021 at 14:41