Solved

Looking for an Online Chart Animation tool

Posted on 2012-12-30
5
460 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
ID: 38732070
Any help would be appreciated!
0
 
LVL 24

Accepted Solution

by:
Echo_S earned 500 total points
ID: 38732488
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
ID: 38745480
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
ID: 38745505
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
ID: 38749583
Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Learn how to download your full Prezi presentation for offline presenting. Prezi doesn’t have to be viewed and shared in a web browser, even with a free account you can download your full presentation to share with others. Be sure to download any vi…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

861 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

30 Experts available now in Live!

Get 1:1 Help Now