![]() 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. |