|
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 -- jackw85 ------------------------------------------------------------------------ jackw85's Profile: http://www.excelforum.com/member.php...o&userid=24332 View this thread: http://www.excelforum.com/showthread...hreadid=379342 |
Seriously no-one knows anything about this??? Couldn't somone at least make a suggestion! -- jackw85 ------------------------------------------------------------------------ jackw85's Profile: http://www.excelforum.com/member.php...o&userid=24332 View this thread: http://www.excelforum.com/showthread...hreadid=379342 |
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 thats not too important. The graph is of single photon diffraction measurements and its 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 its 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" wrote in message ... 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. -- jackw85 ------------------------------------------------------------------------ jackw85's Profile: http://www.excelforum.com/member.php...o&userid=24332 View this thread: http://www.excelforum.com/showthread...hreadid=379342 |
| All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com