excel chart animation

  • Thread starter Thread starter Criss
  • Start date Start date
C

Criss

Hello. I am a student and for a info-class project I have to make in
Excel a chart to be animated. I have to do this without actually typing
code in VBA, but I am allowed to use macros (to record a macro, I
think).
Please tell me, what are the ways I can do this?
 
HI,
Make a chart
Copy the y values to a new area of the worksheet
Next to these, make 3 columns of alternative y values\
Start recoreding; copy and paste each set of y-values over the ones being
used to created the chart.
Turn off recording
Open VBA and add at top Application.ScreenUpdate=False
Add a bottom Application.ScreenUpdate=True

Have fun
Bernard
www.stfx.ca/people/bliengme
 
I've tried it and it doesn't work. If I wrote application.screenupdate
it gave an error. I then tried with Application.ScreenUpdating, it
didn't give the error but when I run the macro nothing happened.
Am I doing something wrong?
Thank you.
 
Back
Top