animating PowerPoint line chart

[JudyL]

Is it possible to animate a line graph by category and series so that when the person clicks their mouse, it advances one segment of one line. When one line is complete it advances the next line one segment at a time each time the mouse is clicked.

 

[SkipVought]

Judy,

I'm assuming that this is MS Graph

Have a slide for each series or data point. Let's assume that I have a chart with 2 data points.

1. Duplicate the chart on on 2 slides.

2. On slide 1 delete the DATA for data point 2

Now start the slideshow. The Chart shows 1 data point. Click the slide to advance. The chart shows 2 data points.

VOLA!

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[JudyL]

Yes, this is in PowerPoint XP. Your solution almost works. It was perfect for the first line. When I get to the second slide, I want to have the first line completed and showing while I click to advance the second line from category to category.

 

[SkipVought]

Please post your source data.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[JudyL]

Thanks for your help. Not sure how to post the file.

 

[SkipVought]

I just need a few rows of sample data from which you are creating you chart along with an explaination of what you want to see on the first slide and the succeeding slides.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[JudyL]

I sent it to support@theofficeexperts.com. I just want the second slide to work exactly like the first but to have the red line (the one that was on the first slide) already displaying on the second slide and then be able to animate just the blue line category by category.

 

[SkipVought]

I'll take a look

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[SkipVought]

JudyL,

I was not able to get your eMail.

Please resend to

skip.metzger at lmco.com (of course remove spaces and substitute @ for at)

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[SkipVought]

JudyL,

Make sure that the Chart Options include Empty Cells NOT PLOTTED. This will make the lines TERMINATE at the end or each segment.

The other thing is that the y-axis MAX value needs to be constant.

So here's how the creation process goes.

1. Start with the Chart/Data table you want to use. Format the y-axis (value axis) - Scale tab - UNCHECK the Auto checkbox for Maximum. This will perserve the max value. Change the Tools/Options - Chart tab: Empty cells not plotted

2. Count the number of series/point segments you want to display -- in our case we have 2 series with 4 datapoints, but we are starting each series with 2 data points initially showing. So we need 6 copies of the chart on 6 slides. Just copy and paste 5 times.

3. On Slide 1, delete the entire second series in the DATA TABLE. Delete data points 3 & 4 in the DATA TABLE.

4. Proceed from slide to slide deleting the series/data points in the DATA TABLE.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[JudyL]

Thanks for your time on this. I really appreciate it. I was hoping for a bit more automatic way of doing it in PowerPoint. Even the new 2003 version can't do it. Thanks again. Have a good holiday