I have a table with Columns as City, Year and Population Growth of City relative to previous Year. I want to create animation in bar chart in which size of bar represents poplation of a city corresponding to Years. Since, I just have the population growth instead of total population till a particular year stored in the table, I would want to add the Growth number of previous years so as to give a rising bars animation. Please help me in writing the expression for calculating the sum of all previous years population growth dynamically during animation.
as of my knowledge we cannot show raising bars when we try to animate the chart. We will have a single bar which raises and falls according to the dimension and the dimension keeps changing with play. i dont think we wil have many bars popup on play.
Thanks for the quick reply Sundar. I just want to show animation which depicts the population size of a city with time. Can you suggest a way to do the same? The problem is I don't have population size for each year. I just have the amount of increase in population for the particular year. So adding the previous year's value dynamically is the main problem that I'm facing currently.
if it a bar chart we can achieve it by "Full Accumulation" option in the expression. I guess even that can be used in an animated bar chart, but the problem is we cannot show many bars getting anumated. U would want to show the increse in populatein by using year as deimension and showing the upward raise. which is not possible. Bec animated bar chart will show only one ba which is going to rasie and fall year wise. only the year changes, If it is not an animated chart then u can very well use "Full accumulate" and use increment data to achive the chart. This option is available in the expresison tab.
IN bubble chart, I've seen animating bubbles whose size grow with a particular dimension. Can my problem be addressed by using Bubble Chart? Like, size of bubbles represents population, which increases with time. And different bubbles represent different cities.