Animated Bar Chart

Topic

New Reply

Hello Loungers,

I have an upcoming presentation in which I would like to present an animated bar chart. I have 5 columns of data, each that represents a different category and about 250 rows. The data are scores from 0 to 10.

I have found this post that does exactly what I am trying to achieve but it is a scatter graph.

http://windowssecrets.com/forums/showthread//162998-Animate-the-drawing-of-Excel-2013-Scatter-Plot-Point-by-Point?p=968775&viewfull=1#post968775

I would be very appreciative if someone could show me how to convert the code to display an animated horizontal bar graph with the categories on the vertical axis and the scores (1-10) on the horizontal axis.. My attempts to do this on my own have been unsuccessful.

Thank you in advance,
X_LD

Reply | Quote

Replies

http://chandoo.org/wp/2010/11/30/excel-animation-without-macros/

Reply | Quote

X_LD,

Here is some code that animates a horizontal bar graph. I have 50 rows in my samples and using a bar graph looks quite cluttered. Are you sure you want a bar graph with 250 rows? Perhaps you may want to change to a line graph. Or do you want to graph just the average of the categories in which case, a bar graph would suffice? I have placed a sample of each.

HTH,
Maud

40021-animateChart1

40022-animateChart2

Reply | Quote

X_LD,

I added a third animation where the averages for the categories are progressively calculated from top to bottom. Has an equalizer effect.

Maud

Reply | Quote

Maudibe,

Unbelievable! That is sooooo…. cool. I am sorry that I was not clear but it is the averages of the categories that I am charting. Even though the first chart with the 49 rows is awesome, the second chart is what I am looking for. I am certainly not on your level with visual basic but I was able to run the animate3 procedure from the anmate2 procedure. Now the categories will roll from left to right then “dance” with the equalizer effect as you described. I also took note of your Pause function and plan to use it in a Worksheet Activate procedure to start the animation several seconds after the chart sheet is activated. I see many applications for using that in the future.

Thanks again, you are a Wizard.

Reply | Quote