Blog of Calc LLC

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, ...

Suppose you own a grocery store and sell apple, banana and carrot. You can use stacked area chart to show how the sales of each product trend over time. Stacked area chart is more visual than regular line charts in this case. Suppose you have the sales volume of apple, banana and carrot for each season of the last year. 1. Select the data. Then click Insert > Charts > Area . Select " Stacked Area ". 2. The chart is below. You can easily tell how each product sells compared with other products in each season. 3. You can edit the chart such as changing the title, adding data labels etc by clicking on the chart you just created and then click on Chart on the menu.