This is from the exercise of Chapter 3:
Small multiples are such an elegant solution to so many graphing problems. Find a graph you think is overly complicated (check your other textbooks for this course or search on #dataviz on Twitter and scroll through the results). See if you can remake the complicated visual using small multiples.
These Excel ninja graphs make you feel good, but they can also leave you feeling a bit daunted by the idea of churning them out at scale. Three possible solutions that I want you to try:
1. Save the finished graph as a new chart type. Just right-click on the graph, and you should see a menu option called Save as Template. It opens some magical place on your computer—don’t move from that spot. Just name your new chart type and save. Then you’ll see a new area in your regular menu of chart choices called Templates. This process will get you 60% to 85% of the way there, depending on the graph type. You’ll still have to do some adjusting, but it gives you a head start in your graph development. Try making a template for a slope graph.
2. More advanced users should try recording a macro. Sounds intimidating, but it isn’t that scary once you get started. Macros are accessible through a new tab you have to tell Excel to add to your toolbar. Follow File to Options and then look in the Customize Ribbon menu. From there you can add the Developer tab to your ribbon. In it, you’ll see a button called Record Macro. Essentially, this records your movements around the spreadsheet and writes code based on those movements. So, you begin recording the macro (name it after your graph type), then make your ninja graph, and then press Stop Recording. In the future, you’ll simply go to the Macros menu and play your recorded steps. Try recording a macro for one of the graphs in this chapter. Be patient. It takes some trial and error. Skip ahead to Chapter 9 for more details on macros for slopegraphs and dot plots.
3. When you recorded your macro, the code Excel wrote in the background is a powerful, if intimidating, way to generate copies of graphs with speed. In Excel-speak, this is called Visual Basic for Applications, or VBA, code, and people have written dozens of coding instructions to make Excel do all sorts of cartwheels and tricks. Conduct a quick Internet search on VBA code to copy graphs with new data. You’ll see several options that you can dump into a new Visual Basic window (right next to the Macros button). Again, code can be complex to work with, so allow yourself a lot of time . . . and coffee.
Submit any requried documentation.
A few points of clarification:
Q1. You are creating a template – a screen grap of that would surfice.
Q2. You can view the steps/code generated in creating a Macro – that is what you submit – here is quick tutorial on doing that:
Q3.Upload the VBA code that you found to work and some screengrabs showing how you tested it,
