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

Excel Dashboards

Books at Amazon.com

# Dynamic and Interactive Charts.

### Dynamic Charts

Alse see Dynamic Charts on the PTS Blog.

### Note for Excel 2007 users:

• Techniques using named ranges will fail if the names of the ranges begin with the word "Chart".
Use names like ChtValues instead of ChartValues.

##### Dynamic Column Chart.

How do you create a chart from a data range that will frequently change in size? Perhaps you collect weekly data, and would like the chart to automatically expand as each week's data is entered.

Contributed by Debra Dalgleish, Excel MVP

Top of Page

##### Another Dynamic Chart??

How do you create a chart from a data range that may change in size? There are many cases in which you would like the chart to automatically expand as new data is entered. Here is yet another example showing how to construct dynamic charts.

Top of Page

##### Chart the Last 12 Months.

You want to create a chart that shows the last twelve months of data. But how do you create a chart from the latest data in a range that grows, without having to manually update the source data range every month? Here is an example showing how to construct a dynamic chart to update automatically.

Top of Page

##### Charting Dynamic Normalized Ranges

Often it is desirable to plot multiple series so that their values are normalized to an initial value of, say, 100. This is particularly useful when comparing performance of stock prices on a relative basis. This article shows how to use dynamic ranges and dynamic charts to display normalized values.

Top of Page

##### Select a Chart Type Using a List Box or Drop Down

Two approaches for changing a chart type using list box or drop down type controls.

Top of Page

##### Interactive Charting by Combo Box or Checkbox.

Would you like to let someone decide what series to plot on your chart? Here are examples showing how to use a Combo Box (Dropdown Box) or Checkboxes to let the user decide what series to display.

Top of Page

##### Interactive Parallel Coordinates Chart

A parallel coordinates chart, or profile plot, is a useful way to compare several sets of observations (here, one set per quarterback) of a combination of different factors (offensive categories). The entire population, or at least a broad set of data, is generally shown in a subdued color (the gray lines in the chart) while one or more individuals are highlighted for inspection (the blue and red lines).

Top of Page

##### Interactive Chart Creation.

Choose on-the-fly where you want your chart to be drawn, and where to find the data you want to plot.

Top of Page

##### Get Information about a Point on a Chart Sheet (simple version).

Put code from this zipped workbook into the code module of a chart sheet, and clicking on a point will provide information about that point. Fairly basic.

##### Get Information about a Point in an Embedded Chart

Put this zipped workbook's modules into your workbook containing charts, embedded ones as well as chart sheets, and clicking on a point will provide information about that point. Fairly complex.

These two items are offered without much explanation for now. They are not well documented, maybe some day I'll get around to it.

Top of Page