Creating and manipulating charts

When an enduser is shown data in tables and matrix controls, their subconscious mind thinks about the relationships between the data that they are presented with. For example, consider the table created in the prior recipe, Creating a Power View report, as shown in the following screenshot:

Here, we recognize the month as a sequence of consecutive periods and associate performance and the change in values from month to month (for example, February is almost twice as good as January).

This analysis requires a bit of thought from the user and is not the most efficient way to present the month-on-month trend—a visual representation is much more effective. This recipe examines the creation and manipulation of charts in Power View.

Getting ready

This recipe uses the same workbook that was used in the prior recipe (Sales Model 2013.xlsx is available from the online resources). Unlike worksheets, Power View reports cannot be copied with the workbook. They must be created...