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 'Pivot Tables'

Update Regular Chart when Pivot Table Updates

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

A reader named Julie has a regular chart that is linked to a pivot table. When the pivot table is pivoted or updated, it may have different numbers of rows and columns, and the chart must be updated manually. Julie asked whether a procedure could be developed to update the chart automatically.
I’ve done this in [...]

Regular Charts from Pivot Tables

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

Sometimes it’s desirable to make a regular chart from a pivot table, but Excel makes it difficult. If your active cell is in a pivot table, inserting a chart automatically inserts a pivot chart. Defining a source data range that intersects a pivot table automatically converts the chart into a pivot table. And once a [...]

Grouping by Date in a Pivot Table

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

You can add flexibility to your data analysis by grouping variables. For example, you may have daily sales figures that fluctuate greatly in value, some days having no sales at all, some days with small values, and some with large values. A plot of this data is very noisy, and it’s hard to see any [...]

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 [...]

Using Pivot Table Data for a Chart with a Dual Category Axis

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

Tony commented on the previous post, Chart with a Dual Category Axis, asking whether I’d use a pareto chart for this data. I commented that it almost was a pareto chart, since at least within each category the data is sorted from high to low. Then I got to thinking, if I put my data [...]

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