Google Sheets - Area chart

In this tutorial we will make an area chart like this:


Area chart is a close variant of line chart. Area chart also shows trend over time. Area chart shadow the area under lines to emphasize size of the magnitude.

Suppose the following data shows revenue and expense of a person for each month of the last year.


1. Select the data. On menu click Insert > Charts. Ignore the chart type recommended by Google Sheets, under Chart type, select Area chart.

2. Now you have an area chart. The blue area shows revenue. The red area shows expense. The orange area shows expenses were higher than revenue in March and December.

Stacked area chart

 Depending on the purpose of your analysis, you may choose stacked area chart instead of the regular area chart. Stacked area chart shows sum of data series at each time point. For example, if a company sells its product to US and Canada market, the sales data for each month is below.


Select the data. On menu click Insert > Charts. For chart type, select Stacked area chart.


 Now you see a stacked area chart showing sales in each country and total sales for each month.

General area chart or stacked area chart

Which one should you choose, general area chart or stacked area chart? It depends on your analysis purpose. If you main interest is the difference between the data series, choose the general area chart. If you are more interested in the sum of the data series, choose stacked area chart.




Comments

Post a Comment

Popular posts from this blog

Excel - Solver examples

Image
Excel Solver is used to solve optimization problems, which is like solving equations. In this tutorial, we will give a very simple example on how to use Excel Solver. Basic example Suppose your car is low on gasoline. The gasoline is $3/gallon. You have a budget of $50. How much gasoline can you buy? Of course, for a problem this simple, we do not even need a Solver to solve the problem. However, the purpose is to teach the users how to use Excel Solver, so we make the problem extremely simple. We have the following framework: Goal: maximize quantity of gasoline Relationship: cost=quantity * unit price Constraint: cost<=budget 1. In cell B1, we enter unit price "3", in cell B4, we enter the budget 50. In cell B2, we just enter an arbitrary number as the number of gallons. We entered 5. In cell B3, we enter the formula "=B1*B2" to let it be the cost, which equals to 15. 2. Click Solver under the Data menu. 3. A Solver dialog window pops up. In "Set objective...
Read more

Excel - Pivot Table

Image
Pivot table is a powerful tool to summarize data and examine data patterns in Excel. Suppose we have 200 rows of data from a farmer, which sells fruit (apple, banana, orange) and vegetable (carrot, spinach) to clients in the US or Canada market, like below: 1. Select Insert > PivotTable 2. Click on PivotTable, then select the data range and where to place the PivotTable. When selecting the data range, the header must be selected. 3. Drag "Category" to Row labels, "Item" to Column labels, "Amount" to Values, and at last, drag "Market" to Report Filter. Note: You can user different fields for filter, row label or column label, depending on your business logic. You do not have to fill all the 4 fields, even only dragging the "Amount" into the "Values" field still produces a nice PivotTable. Again, all depend on your business logic. 4. The result is below. Notice that some cells are blank in the PivotTable. The reason is obvio...
Read more

Excel - Convert between mile, kilometer and meter

Image
Excel has a very useful function convert numbers from one measure unit to another, for example, from Fahrenheit to Celsius, or from mile to kilometer. The function is  CONVERT . For example, if we want to convert temperature 1.2 mile to kilometer, how to do it? One way is using the equation: 1 mile = 1.60934 kilometer If you do not know the conversion equation, you can just use the CONVERT function. Since kilometer is not a basic unit in the CONVERT function, you need to convert mile into meter first and then to kilometer. For example: =CONVERT(1.2,"mi","m") will turn mile into meters. If you divided the above number by 1000, you will get kilometer. =CONVERT(1.2,"mi","m")/1000 See the following figure for example. You can also convert kilometer into mile in a similar way. You first need to convert kilometer into meter, then use the CONVERT function. The formula is: =CONVERT(2.35*1000,"m","mi")
Read more