Video transcripts: In this section, we’re going to start to look at what many people consider to be one of the greatest strengths of Excel and that is the ability to create really good Graphs and Charts. Why do people use Graphs and Charts in Excel? Well, usually it’s to strengthen a message or sometimes to actually give the message itself. Re: excel do not show graph map chart The map chart shows on my excel ribbon. Execute pl sql procedure. However when I select the data and click insert and choose maps it does not give me any maps rather it shows bar charts and pie charts. As the saying goes, a picture can paint a thousand words. And very often, particularly with complex data. A picture can help people to understand the data without getting too baffled by all of the numbers. Now, I should warn you that the area of Graphs and Charts in Excel is a pretty vast area. So, we’re going to start with the basics as usual. I’m going to use some very straightforward data here about the lengths of a number of rivers in Africa and the drainage basins for some of the rivers. What I’m going to do first of all is to create a straightforward Graph or Chart to illustrate the lengths of those eight rivers. Let’s just ignore the drainage basins for a moment. What I’m going to do, first of all, is to select the data that I want to draw the Graph or Chart of. I select from A1 down to B9. I go to the Insert Tab. One of the groups on the Insert Tab is Charts. I’m going to click first on Recommended Charts because once you’ve selected some data, what Excel 2016 can do for you is to recommend a suitable type of chart. The recommendations it makes are on the left here. ![]() There are four of them. First of all, it says Clustered Column. Now, I’m going to assume you’re not really familiar with types of Graph and Chart (although I know many of you will be). I’ll briefly explain each as we go along. A Clustered Column basically means we have vertical columns and each column corresponds to a category. Excel assumes in this case that the categories are in column A, so A2 down to A9. Simcity 5 download. So, we have a category, Okavango, and a category Orange and so on. On the vertical scale, on the vertical axis, it plots what it calls the value. Values, in this case, are the lengths of the rivers. As you can see, its taken each of our rivers and plotted a column. Now, note the little summary underneath the chart. The Clustered Column Chart is used to compare values across a few categories. Use it when the order of categories is not important. The second option it offers is really similar but it’s flipped over. It’s what’s called a Clustered Bar Chart. This time the categories are on the vertical axis, the values are horizontal. So you’re looking at the lengths of the rivers as horizontal bars.
0 Comments
Leave a Reply. |