Reddit reviews Excel Dashboards and Reports

Here is an image of something I threw together that could work for presenting data across two distinct groups, as you are describing. It isn't a pie chart, although you could use the same philosophy of creating two colors for your series and using labels to differentiate each of the boys and girls. You could also do an exploded pie, but I'm not a big fan of them (to each his own, though). I based this build off of a blog post on BaconBits, an Excel blog by the author of Excel Dashboards (among other books). The process is a bit cumbersome, but it can create some cool looking chart effects for dashboards. The post explaining the process can is found here. Here is the spreadsheet if you want to explore it. Good luck.

I really liked Excel Dashboards and Reports by Michael Alexander and John Walkenbach. I have a little Excel library at my desk and every time I reach for that one I have to track it down because it keeps getting borrowed.

It's designed so you could hand it to someone who's never used excel and to take them up to having a grasp on VBA and some advanced formulas like array formulas. I haven't picked it up in about a year it doesn't sound like it would be a massive learning jump for yourself.

When it comes to charts/reports etc there are actually 2 books that I'm still deciding if I should buy or not. Both have been recomended to myself but I'm waiting until payday before buying them myself so can't testify to how good they actually are.

http://www.amazon.co.uk/dp/1118519655/ref=wl_it_dp_o_pC_S_ttl?_encoding=UTF8&colid=26FRQZR9FPSJT&coliid=I2TLB44KQWBWAS

http://www.amazon.co.uk/dp/1118490428/ref=wl_it_dp_o_pC_nS_ttl?_encoding=UTF8&colid=26FRQZR9FPSJT&coliid=I3LYA71RKLXI19