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