Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default export excel charts for animated gif

Hi. I want to make an animation from excel charts. I have already written a
Visual Basic program that saves the charts as static gif files. I don't know
much about animation, but when I tried to create a short video using a gif
animation program, the file size was big because I didn't know a smart way to
tell the animation program that the excel files were mostly similar from one
image to the next.

Is there a particular gif animation program that works well with charts
exported from Excel (for example, reading the different parts of the excel
chart as separate "objects" for animation)?

Thanks,

Parke
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default export excel charts for animated gif

On Sun, 9 Jul 2006, in microsoft.public.excel.charting,
parkesarah said:

Hi. I want to make an animation from excel charts. I have already written a
Visual Basic program that saves the charts as static gif files. I don't know
much about animation, but when I tried to create a short video using a gif
animation program, the file size was big because I didn't know a smart way to
tell the animation program that the excel files were mostly similar from one
image to the next.

Is there a particular gif animation program that works well with charts
exported from Excel (for example, reading the different parts of the excel
chart as separate "objects" for animation)?


Have you considered saving the static parts, such as axes and grids,
with no data as one static gif, then saving the changing parts as
minimal Excel charts with no axes or grids? Then create an animated gif
with transparency (I don't know if this part is possible) and finally
presenting the animation in HTML on top of the static backdrop.

Alternatively, could you find some MPEG tools, which surely have the
redundancy compression problem licked?

Finally, if you can't do any of that, look at your graphs to see if
there is any fluff you could stand to lose completely, like big colored
bars and heavy grids.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 29
Default export excel charts for animated gif

You can use Photoshop for example.
Copy each single picture from excel to Photoshop.
To copy, use Excel-Menu Shift-Edit, then you see "Copy Picture".
Copy cells behind a chart, not the chart. Make charts transparent.
Paste each single picture in a new PS-layer. Sort them vice versa.
Save as gif. Pictures are played one after the other.

Greetings,
Holger.

"parkesarah" schrieb im Newsbeitrag
...
Hi. I want to make an animation from excel charts. I have already
written a
Visual Basic program that saves the charts as static gif files. I don't
know
much about animation, but when I tried to create a short video using a gif
animation program, the file size was big because I didn't know a smart way
to
tell the animation program that the excel files were mostly similar from
one
image to the next.

Is there a particular gif animation program that works well with charts
exported from Excel (for example, reading the different parts of the excel
chart as separate "objects" for animation)?

Thanks,

Parke



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to Microsoft Excel from IE AndreasSjoberg Excel Discussion (Misc queries) 2 October 19th 05 02:41 PM
Excel should heavily extend the options for black-white charts Dan from Sweden Charts and Charting in Excel 0 October 17th 05 01:26 PM
Pasting excel sheets with charts Duane Charts and Charting in Excel 1 May 25th 05 09:07 PM
Displaying charts from excel 2003 in excel 2002? nick_h Excel Discussion (Misc queries) 0 May 9th 05 02:41 AM
Access -> Excel: How to export fields > 255 characters Gabriel Martin Excel Discussion (Misc queries) 1 March 9th 05 01:37 PM


All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"