Peltier Technical Services, Inc.
 

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


Peltier Tech Chart Utility

 

Excel Dashboards

 

Books at Amazon.com

 

Dynamic and Interactive Charts.


 

Introduction

Dynamic Charts

Alse see Dynamic Charts on the PTS Blog.

Worksheet Controls for Chart Interactivity

VBA Chart Interactions

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.

This page shows how to construct such a dynamic chart.

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



 

Page copy protected against web site content infringement by Copyscape

Peltier Tech Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.


Peltier Technical Services, Inc.

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

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

Microsoft Most Valuable Professional

My MVP Profile