Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS Blog

Peltier Tech
Chart Utilities

Books at Amazon.com

Buy me a coffee

If this topic or the whole site has been helpful, please support further development by treating me to a cup of coffee.

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

A number of examples:

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.

Peltier Technical Services, Inc.

Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2009. 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