Microsoft Office Tutorials and References
In Depth Information
Excel Macro Examples
Figure 13-15 demonstrates how you can give your audience a quick-and-easy way to see the same
data on different charts. Don’t laugh too quickly at the uselessness of this example. It’s not
uncommon to be asked to see the same data in different ways. Instead of taking up real estate, just record a
macro that changes the Chart Type of the chart. Your clients will be able to switch views to their
Figure 13-15: You can give your audience a choice in how they view data.