Dynamic Chart Links.
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.
Peltier Tech web site
Several examples of dynamic charts:
Alse see Dynamic Charts on the PTS Blog.
Debra Dalgleish - Contextures
Some easy to follow examples:
Naming Names
Use Range Names in Formulas: Dynamic Charts
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://oaltd.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]
Note for Excel 2007 users: Techniques using named ranges will fail if the names of these ranges begin with the word "Chart". Use names like ChtValues instead of ChartValues.
|