PTS Blog

Main menu:

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Excel User Conference

2008 US East Coast Excel User Conference
September 24-26, 2008
Atlantic City, NJ

Subscribe

Site search


Recent Posts

Recently Commented

July 2008
S M T W T F S
« Jun    
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archive


 

Categories


 

Archive for 'Dynamic Charts'

Easier Interactive Multiple Line Chart

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Interactive Multiple Line Chart I showed how to make an interactive chart that allows the user to select from among a number of series using a listbox, and the selected series is displayed in a chart.

A similar technique is described in Interactive Parallel Coordinates Chart on my web site, and I used this technique [...]

Interactive Multiple Line Chart

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In the Microsoft charting newsgroup, SKP asked how to make a chart that he could easily change from one series to another. This post will detail the steps to make an interactive chart that allows the user to select from among a number of series using a listbox, and the selected series is displayed in [...]

Re: Abortion Ratios 1980-2003

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Chart Design: Abortion Ratios 1980-2003 Jorge Camoes shows a nice panel chart of Abortion Ratios vs. Year (1980-2003) for different age groups, taking US Census Bureau data. I reproduce a few panels of Jorge’s chart below; click on the chart to see his entire panel chart.

Jorge points out the downward trend in the curves [...]

Dynamic Chart Source Data

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

A dynamic chart can be constructed using dynamic ranges that change in size as data is added or removed. This technique is very powerful: you can define flexible ranges limited only by your ability to write an appropriate Refers To formula.
One imitation of this approach is that it can only account for dynamic numbers of [...]

Physics Lesson

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

A high school physics teacher was asking questions in the Excel programming newsgroup about his VBA procedure that accepted input values (time, position, velocity, and acceleration) from the workbook, calculated values of position and velocity vs. elapsed time, and charted the results. I answered a couple of his VBA questions, but I suggested that he [...]

Dynamic Charts

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

Oh no, not another article about Dynamic Charts! There must be dozens of articles on the interweb about dynamic charts, some of them even useful. I didn’t even write the first Dynamic Charts article on my web site; that honor goes to Debra Dalgleish’s Dynamic Column Chart. Debra enjoyed writing that tutorial so much, she [...]

Dynamic Chart using Pivot Table and VBA

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Using Pivot Table Data for a Chart with a Dual Category Axis, I showed how to make a Chart with a Dual Category Axis using a pivot table to properly arrange the source data. I generally prefer using a regular chart, because pivot charts are pretty inflexible when it comes to formatting. Unfortunately, a [...]

Dynamic Chart using Pivot Table and Range Names

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Using Pivot Table Data for a Chart with a Dual Category Axis, I showed how to make a Chart with a Dual Category Axis using a pivot table to properly arrange the source data. I generally prefer using a regular chart, because pivot charts are pretty inflexible when it comes to formatting. Unfortunately, a [...]

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