From the course: Excel 2019 for Mac Essential Training “ - [Instructor] One of the great things about creating charts in Excel is that you can summarize many data sets using more than one type of chart. If the first type of chart you select doesn't work, you can try another. If all you want to do is change the chart's layout, such as by moving and removing the title, or perhaps, changing a background color, you can select from one of several premade layouts to do so. I'll demonstrate
these techniques in this movie. My sample file is the ChartLayout workbook, and you can find it in the Chapter 7 folder of the Exercise Files collection. The Column Chart I have on the right side of the screen, this summarizes sales data, or order counts, for four different categories across three different years, and each of the years is represented by a separate color. Lets say that I want to make my chart narrower, and that means that I want to have all three of the years in a single column
for each of the categories. I can change the chart type by clicking the chart, so it's selected, and then on the Chart Design Contextual tab, I can click the Change Chart Type button, and select a new chart. In this case, I want a Stacked Column chart, so I will point to Column, and then the second item on the top row is Stacked Column, so I'll click that, and my Chart Type has changed. It contains all of the data that I had before, but now you see it's not quite as spread out, and if I wanted,
I could make it narrower. Now if I want to change the charts layout, and that is different from the charts formatting, I can click the chart, go to the Chart Design Contextual tab on the ribbon, and then click the Quick Layout button. It's at the almost the far left edge of the Ribbon tab. In here, I see a number of different layouts. So lets say that I want to have the legend at the right, so I'll click the one here on the top left, I still have my title, that's Layout 1, I'll click it, and ya
see that I now have my stacked values, again, each year is a different color, and the categories along the bottom, and the legend has been moved to the right, and of course, you can drag or delete individual elements as well. For example, if I wanted to get rid of the title, I could select it, press the Delete key, and it's gone. After you create a chart, you can change everything about it, including its layout or even its type. Keep trying combinations of Chart Type and Layout until you find
the one you like. Contents
How do I change the layout of a chart in Excel?Select a predefined chart layout
Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Layouts group, click the chart layout that you want to use.
Which command button gives options to change the formatting and layout of the Axis?Right-click the chart axis, and click Format Axis. In the Format Axis task pane, make the changes you want. You can move or resize the task pane to make working with it easier.
What is Quick layout command in Excel?You can use Quick Layout to change the overall layout of the chart quickly by choosing one of the predefined layout options. Step 1 − On the Ribbon, click Quick Layout. Different predefined layout options will be displayed. Step 2 − Move the pointer across the predefined layout options.
Where do I find chart tools in Excel?Click INSERT > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. If you don't see a chart you like, click All Charts to see all the available chart types.
|