Excel Chart Add-Ins | Training | Charts and Tutorials | Peltier Tech Blog

Warning: include(): http:// wrapper is disabled in the server configuration by allow_url_include=0 in /www/eh7701/public_html/Excel/Charts/DynamicChartLinks.html on line 18 Warning: include(http://peltiertech.com/Common/ptstower.php): failed to open stream: no suitable wrapper could be found in /www/eh7701/public_html/Excel/Charts/DynamicChartLinks.html on line 18 Warning: include(): Failed opening 'http://peltiertech.com/Common/ptstower.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /www/eh7701/public_html/Excel/Charts/DynamicChartLinks.html on line 18

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.

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.

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2011. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile