LINKED EXCELL SPREADSHEET CELLS

[TERRY]

I add new dates weekly on my linked spreadsheets but my
linked data in powerpoint does not advance to the new date
line. How do I make the linked cell automacally advance
to the next weeks line on the spreadsheet with having to
copy and paste the new line into powerpoint

 

[Kurt]

Hi Terry,
Maybe this is an option: www.take-off.as/datapoint
Regards
Kurt.

 

[Brian Reilly, MS MVP]

Terry,
I copied the following off Jon Peltier's, an Excel MVP, web site on
this topic. The trick is to used named ranges set in a formula. I do
this often with VBA code but it can also done directly with formulas
as well.

Here are a few of the many web links that deal with dynamic charting.
This is not intended to be a complete list, nor are the entries in any
particular order.

John Walkenbach - The Spreadsheet Page
http://j-walk.com/ss/excel/
Dynamic Chart - Demonstrates how to make a chart's data series display
data based on the active cell position.

Stephen Bullen's Excel Page
http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=FunChrt1.zip
This file demonstrates how to set up a chart so that it automatically
includes new data as you type it in.

Tushar Mehta
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
Dynamic Chart Tutorial

Erlandsen Data Consulting
http://www.erlandsendata.no/downloads/dynamiccharts.zip
Chart example that plots the latest 12 months of data.

Bernard V. Liengme
http://www.stfx.ca/people/bliengme/exceltips.htm#Dynamic chart
Dynamic chart: add new data and the chart expands.

Andy Wiggins - BygSoftware
http://www.bygsoftware.com/examples/examples.htm
Update graph data without changing the source ranges. Useful if you
produce graphs on a regular basis.

Rodney Powell - Beyond Technology
http://www.beyondtechnology.com/geeks021.shtml
Charting Dynamic Data

PRIME Consulting Group
http://www.primeconsulting.com/faqs/faq4650.html
How to Create Dynamic Charts in Excel 97

MSKB - Microsoft Knowledge Base
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q183446
XL: Using Defined Names to Automatically Update a Chart Range
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q157940
XL97: How To Create a Dynamic Chart Using Visual Basic [not using
defined names -JP]
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q213780
XL2000: How to Use Visual Basic to Create a Dynamic Chart [not using
defined names -JP]

Brian Reilly, PowerPoint MVP