Waterfall Chart
Archive for Wednesday, July 16th, 2008
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 [...]
Posted: Wednesday, July 16th, 2008 under Data Techniques, Pivot Tables, VBA.
Comments: none
Nice Dashboard Examples
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
XL Cubed (parent company of BonaVista Systems, maker of the MicroCharts add-in for Excel) has shown some very effective dashboard report examples in a couple of recent posts.
In 2008 Excel Dashboard Competition Winners the winners of the 2008 Excel Dashboard Competition are announced:
1. Wade Stokes – International Bank Dashboard
Displaying many disparate Banking Key Performance Indicators, [...]
Posted: Wednesday, July 16th, 2008 under Charting Principles, Dashboards, Example Charts.
Comments: 2
