Thread: create progressive graph for slide show

Hello,

I am fairly good at the basic in excel but I can't work out a quick way of doing this:

I have a large table of data about 50 by 8000 and am using it to plot graphs. The problem is I want to create a slideshow to show at a seminar which will start off using just the first row of data and then progressively add more rows and display each line graph one at a time. I can't see any simpler way of doing this except to copy and paste each graph into PowerPoint on a time which would take for ever!

Ideally I would like the scale to update automatically but that’s not too important.

The graph is of single photon diffraction measurements and it’s for an undergraduate project if anyone wants to know. I hope someone can help.

If I don't get help by midday tomorrow thanks but it’s over.

Jack

Seriously no-one knows anything about this??? Couldn't somone at least make a suggestion!

I would suggest that rather than taking it into power point, you make your
graph based on a pivot table go to Excel in your presentaion and use the
pivot table options to add more data for your presentation, other wise your
idea of just pasting pictures in Power point is probably as good as you will
get

You could of couse make everything be invisible except the data set you are
working on and add new lines on the same chart this is a lot more busy work
than the pasting of entire charts.

"jackw85" wrote:

>
> Hello,
>
> I am fairly good at the basic in excel but I can't work out a quick way
> of doing this:
>
> I have a large table of data about 50 by 8000 and am using it to plot
> graphs. The problem is I want to create a slideshow to show at a
> seminar which will start off using just the first row of data and then
> progressively add more rows and display each line graph one at a time.
> I can't see any simpler way of doing this except to copy and paste each
> graph into PowerPoint on a time which would take for ever!
>
> Ideally I would like the scale to update automatically but that’s not
> too important.
>
> The graph is of single photon diffraction measurements and it’s for an
> undergraduate project if anyone wants to know. I hope someone can
> help.
>
> If I don't get help by midday tomorrow thanks but it’s over.
>
> Jack
>
>
> --
> jackw85
> ------------------------------------------------------------------------
> jackw85's Profile: http://www.excelforum.com/member.php...o&userid=24332
> View this thread: http://www.excelforum.com/showthread...hreadid=379342
>
>

"jackw85" <jackw85.1qoaye_1118847926.0898@excelforum-nospam.com> wrote in
message news:jackw85.1qoaye_1118847926.0898@excelforum-nospam.com...
>
> Hello,
>
> I am fairly good at the basic in excel but I can't work out a quick way
> of doing this:
>
> I have a large table of data about 50 by 8000 and am using it to plot
> graphs. The problem is I want to create a slideshow to show at a
> seminar which will start off using just the first row of data and then
> progressively add more rows and display each line graph one at a time.
> I can't see any simpler way of doing this except to copy and paste each
> graph into PowerPoint on a time which would take for ever!
>
> Ideally I would like the scale to update automatically but that's not
> too important.
>
> The graph is of single photon diffraction measurements and it's for an
> undergraduate project if anyone wants to know. I hope someone can
> help.
>
> If I don't get help by midday tomorrow thanks but it's over.
>
> Jack
>

Jack,

seriously I don't know how to do this but I have a Powerpoint idea that
*might* help and a possible excel idea.

Create your full chart and paste onto a slide with a plain gray background
or this might get tricky. Add a gray rectangle to cover the datapoints you
do not want to display; duplicate slide, move left edge of rectangle,
duplicate slide, repeat ad infinitum until all datapoints are displayed ...

The only other Excel idea would be to have a display variable on the
worksheet behind your chart and as this is incremented or populated then
additional cells are copied then more series are displayed. e.g. if the cell
is 1 then multipy a corresponding entire series by 1 and the data will pop
from the zero line onto the chart, or if 1 then display series 1, 2 display
series 1 and 2 etc. For example you have all of your 50x8000 datapoints -
create another 50x8000 datapoints that are a result of a simple function -
if series1 is sheet1!B2:B8002 and series 2 is in sheet1!C2:C8002 then create
the series1 data you want to plot in sheet2!B2:B8002 as =(sheet1!B2:B8002 *
sheet2!B$1) and series 2 data in sheet2!C2:C8002 as =(sheet1!C2:B8002 *
sheet2!C$1). If B1 is 1 then the series1 will plot as the values otherwise
these will all plot as zero, so on for C1 for series2 etc.

Neither are tidy but maybe one will work for you

PK

>
> --
> jackw85
> ------------------------------------------------------------------------
> jackw85's Profile:
> http://www.excelforum.com/member.php...o&userid=24332
> View this thread: http://www.excelforum.com/showthread...hreadid=379342
>

Thanks for the help, I think I'm going to try and get a 4th year to use matlab and do it. I don't think I could work out how to do that in a day, thanks anyway.

For certain graph types animated with certain (simple) animation types,
it is possible to to show one series at a time. Create the chart with
all the series showing in XL, copy and paste into PP, select the chart
in PP and select Custom Animation. Experiment with the choices -- stick
with the simpler ones such as 'appear' or 'dissolve' -- until you find
one that lets you animate one series at a time.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article <jackw85.1qoaye_1118847926.0898@excelforum-nospam.com>,
jackw85.1qoaye_1118847926.0898@excelforum-nospam.com says...
>
> Hello,
>
> I am fairly good at the basic in excel but I can't work out a quick way
> of doing this:
>
> I have a large table of data about 50 by 8000 and am using it to plot
> graphs. The problem is I want to create a slideshow to show at a
> seminar which will start off using just the first row of data and then
> progressively add more rows and display each line graph one at a time.
> I can't see any simpler way of doing this except to copy and paste each
> graph into PowerPoint on a time which would take for ever!
>
> Ideally I would like the scale to update automatically but that=3Fs not
> too important.
>
> The graph is of single photon diffraction measurements and it=3Fs for an
> undergraduate project if anyone wants to know. I hope someone can
> help.
>
> If I don't get help by midday tomorrow thanks but it=3Fs over.
>
> Jack
>
>
> --
> jackw85
> ------------------------------------------------------------------------
> jackw85's Profile: http://www.excelforum.com/member.php...o&userid=24332
> View this thread: http://www.excelforum.com/showthread...hreadid=379342
>
>