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. In here, I see a number of different layouts. It's at the almost the far left edge of the Ribbon tab. 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 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. 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. 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. 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. 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. My sample file is the ChartLayout workbook, and you can find it in the Chapter 7 folder of the Exercise Files collection. I'll demonstrate these techniques in this movie. 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. If the first type of chart you select doesn't work, you can try another. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |