Excel: Power View Chart with Vertical Multiples

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Say that you have a great chart in Power View. You want to produce that chart for each region in the company. Drag the Region field to the Vertical Multiples area of the Power View Fields list. Your chart will be replicated for each region.

Use the Grid Height and Grid Width choices on the Layout tab to control the arrangement of the charts.

For more resources for Microsoft Excel