Chapter 46. Power View

Questions answered in this chapter:

  • How can I prepare data for Power View?

  • What kind of charts can I create with Power View?

  • How can I filter Power View charts?

  • How can I display sales data by state or country?

  • How can I turn a time series scatter chart into an animated experience?

  • How can I use Multiples to create many charts easily?

If you have Microsoft Excel 2013 Pro Plus or Office 365, Power View for Excel is available to you. In this chapter, you learn the basics of how Power View can be used to create amazing charts and graphics. Basically, Power View creates a new sheet in your workbook that acts like a blank canvas on which you can create several charts. You can map sales onto a US or world map and even turn a scatter ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.