Certainly not wrong in one sense because you can do it but not recommended. So, that's why the recommendation was earlier, don't mix totals and details together. Go back to Insert and choose Column and Clustered and there we see what's happening. I think most of the time it makes for an unsatisfactory chart. Going back to the data, I will include the totals. Now, I want to show you what would happen if we did include the totals. The numbers down the left hand side, need a description perhaps but with the data nearby we could forgo that even. Of course we will click that and type that in later. Each Cluster of Columns is identified by a month. But let's say as we look at it briefly here we've got a Legend across the bottom that explains what each of the colors mean. We've got a chart, not perfect on all respects. Column, probably the most common chart type in Excel and Clustered Column within that, the most common type. Insert tab in the Ribbon has some chart choices right here. In this case let's say we do not want the totals along with the detail, just the detail itself for each of the six months for the four regions. And most of the time when you're selecting data to go into a chart, it's contiguous data in one rectangular grouping. So when we select data to put into a chart, we usually include those labels along with the numbers.
And in the two examples we see to the right we do see how those are being used.
What you wouldn't necessarily know at first is that adjacent labels for example, these labels right here that describe the data in the columns below, and the labels that we see in column A that describe the data in the rows to the right, this information can be used intelligently in charts. Now, we might not want to show all the numbers here and often if you've got totals and details together, it's probably not a great idea to show both of them. We're looking at a file called Chapter One Chart Creation. We've got some numbers over here on this Worksheet, it's called Data Selection. With no numbers you really can't create a chart. In Excel, a chart means you've got numeric data that you'd like to depict graphically. The first step to creating a chart in Excel is to identify the data that you wish to show in a chart.
0 kommentar(er)
