From the course: Excel: PivotTables in Depth
Join today to access over 24,700 courses taught by industry experts.
Change a PivotChart’s layout
From the course: Excel: PivotTables in Depth
Change a PivotChart’s layout
- [Instructor] When you create a pivot chart in Microsoft Excel, the program uses a basic layout to determine when and where to display elements such as the chart title, a legend representing each data series, axis titles, labels, and other elements. The basic layout Excel uses is good enough for a quick look at your data, but you'll probably want to change it based on your own needs. And in this movie, I will give you the tools that you need to do so. My sample file is 06_05_Layout, and you can find it in the Chapter 6 folder of the Exercise Files collection. On Sheet 1 of this workbook, I have a pivot chart, and if I want to change this layout, I need to click it so that I get access to the three contextual tabs on the ribbon. In this case, I want to use the design contextual tab. So I'll click that. And then over on the left in the chart layouts group, I will click Quick Layout, and I can select one of the layouts that are there. If I move my mouse pointer over a layout, then I get…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.