create progressive graph for slide show

  • Thread starter Thread starter jackw85
  • Start date Start date
J

jackw85

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
 
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 said:
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
Click to expand...

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
 
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
 
Back
Top