tag:blogger.com,1999:blog-9092970177046142644.post8064777521938241930..comments2024-02-15T23:26:05.800-08:00Comments on Excel for Educators: How Stacked Bars Stack UpThe Science Goddesshttp://www.blogger.com/profile/02846516022505481326noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-9092970177046142644.post-85058774669621195972011-10-20T17:31:42.374-07:002011-10-20T17:31:42.374-07:00Thank you!
I'm also thinking about how these ...Thank you!<br /><br />I'm also thinking about how these representations will work for different audiences. The group I have in December will need high level views of things. If you work with Seattle schools and have 40K students' worth of data, you may well need different views than a teacher in a classroom. Both are important stakeholders, but the choice of visual could be unique.The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-42399837584580543692011-10-18T12:34:18.678-07:002011-10-18T12:34:18.678-07:00Interesting suggestion. I always think about line ...Interesting suggestion. I always think about line graphs being used to show trends (and I do have different data that can be incorporated). But it would certainly be another way to have them play with things. <br /><br />I know that distribution is going to be a big deal with this crowd. With the upcoming changes to the way standardized testing is evaluated, we're going to need to start looking for growth (i.e. number of kids in Level 3 this year vs. last year). We could use a traditional bar graph for this, but I'm hoping to find something a little more "glanceable."The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-47065297973424417122011-10-18T12:18:06.368-07:002011-10-18T12:18:06.368-07:00For this kind of data it's pretty obvious that...For this kind of data it's pretty obvious that the total is 100%, so you don't need to stack the data. Clustered bars may be more useful so you could compare, for example, 4th and 5th graders with a score of 3. (Since the stacking removes the common baseline, these are harder to compare.)<br /><br />Since the different grades are in order and are uniformly spaced, I would skip the bars and use a line chart. You can see small differences very clearly as slight slopes in the lines.Jon Peltierhttp://peltiertech.com/WordPress/noreply@blogger.com