Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2014
    Location
    Vancouver, BC
    Posts
    19
    Thanks
    18
    Thanked 0 Times in 0 Posts

    Animated Bar Chart

    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/sho...l=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
    Last edited by X_LD; 2015-03-28 at 00:59.

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    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

    animateChart1.png

    animateChart2.png
    Attached Files Attached Files

  4. The Following User Says Thank You to Maudibe For This Useful Post:

    X_LD (2015-03-29)

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    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
    Attached Files Attached Files

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    X_LD (2015-03-29)

  7. #5
    New Lounger
    Join Date
    Dec 2014
    Location
    Vancouver, BC
    Posts
    19
    Thanks
    18
    Thanked 0 Times in 0 Posts
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •