Excel: How to make a time series using dynamic table and chart with accumulation of values in the row?

0

I would like to make a time series chart that would indicate the values accumulated over time. So it would not be a zig-zag line, it would be a line denoting an evolution, as the values are accumulated.

To illustrate, attach two images. The first one I was able to do with the PivotTable and PivotChart features. It shows the actual values and the zig-zag line. The second (which is what I like) I did "on hand", just to illustrate here, I could not do automatically. How could that be?

The data is as follows:

Ano     Qtt 
1945    1 
1961    1 
1964    1 
1966    2 
1970    1 
1971    1 
1972    1 
1973    1 
1980    1 
1981    3 
1982    1 
1983    1 
1984    2 
1986    3 
1987    4 
1988    1 
1989    4 
1990    6 
1991    11 
1992    5 
1993    13 
1994    6 
1995    11 
1996    14 
1997    23 
1998    7 
1999    12 
2000    12 
2001    20 
2002    19 
2003    58 
2004    30 
2005    69 
2006    223 
2007    201 
2008    113 
2009    71 
Ignorado    28 
Total Geral 981

    
asked by anonymous 18.12.2017 / 11:46

1 answer

1

Solution

You can use the Waterfall graph to display the accumulated values.

Footsteps

1. Select the data:

Select the data to be viewed on the accumulation chart.

2.Insertchart:

InsertthegraphinInserir>GráficosRecomendados>TodososGráficosandchoosetheCascade.

Result

Thegraphillustratesthecumulativevalueandhowmuchyouaccumulatedineachyearabovethebar.

    
18.12.2017 / 17:10