Solved

Looking for an Online Chart Animation tool

Posted on 2012-12-30
5
458 Views
Last Modified: 2013-01-06
I am looking for an online tool that will create a line or bar chart that will be saved to a GIF format so it can become animated. I think I can do this in Excel but It would be faster for me if I used an online tool.

For example, I have a five year data series that I want to show as a animated gif showing the overall annual increase. e.g. the years are 2008 to 2012. the data is 80, 90, 100, 110, 120. I want to see the graph growing each year. This means I need to save a image file for each annual progression and then combine them into a GIF file. Then I want to post the GIF file to Twitpic and tweet it to my followers for them to digest and discuss. The GIF file will show the increase over and over again thus getting some attention to the issue I am illustrating. Thanks for your help!
animated-traffic-chart.gif
0
Comment
Question by:Scruples89
  • 3
  • 2
5 Comments
 

Author Comment

by:Scruples89
Comment Utility
Any help would be appreciated!
0
 
LVL 24

Accepted Solution

by:
Echo_S earned 500 total points
Comment Utility
I don't think you're going to find anything this specific. As you mentioned, you will need to create the chart in Excel and export images.

I'd probably do it in PowerPoint because it's easy to animate there. Or, better yet, make a series of slides, adding the next year on a new slide. Then choose File | Save As and in the Save as Type dropdown choose GIF (or PNG or JPG) to save each slide as an image, then use a GIF creation tool to create the animated GIF.

If you could use a video instead of an animated GIF, then you could save the PPT file as a video. That's also assuming you're using PPT 2010 or 2013, both of which have native video-save capability. (With previous versions, you'd have to use a converter or screen grab software.) 2010 saves as WMV, while 2013 does both WMV and MP4, although of course both could be converted to other formats (MOV, etc.) once created.

If you go the video route, then create the chart on a slide and animate it. Select the chart, click the Wipe animation on the Animations tab, then click the Effect Options button and select an option there if you want to animate the data points one at a time. Set a transition time for the slide that is as long as you want the entire sequence to be (probably only 4 or 5 seconds, I'd guess.) When you save as video, PPT will make the animations occur automatically.
0
 

Author Comment

by:Scruples89
Comment Utility
That's great answer thank you!  I want to use a Animated gif because the animation happens automatically in the twitter client rather than having to click the video to play it. I want to attract attention to a point I am making by animating it. I'd like to be able to do this as quickly as possible. For example, if I could highlight a set of numbers, right click on it and choose "Create Gif Chart animation" and have it so I could save it to my hard drive or upload it to my twitpic account. That would be fantastic.
0
 
LVL 24

Expert Comment

by:Echo_S
Comment Utility
You'll have to create images and make the GIF out of those. As I explained, you can do the chart in PPT and save it (or them) as images from PPT, but you cannot make the animated GIF from PPT.

Here's a free online GIF creator. http://makeagif.com/
0
 

Author Closing Comment

by:Scruples89
Comment Utility
Thanks!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

This article shows how to simulate drawing numbers or names from a hat or bag using vba in PowerPoint and prevents duplicate items being selected. It’s not difficult to choose a (semi) random number in vba. The RND function returns a decimal numb…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now