Friday, July 04, 2008 Register Login
Search this Site:   Go
 
  Weather Minimize
 
 Print   
  UsersOnline Minimize
Membership Membership:
Latest New User Latest: acarlin
New Today New Today: 0
New Yesterday New Yesterday: 0
User Count Overall: 152

People Online People Online:
Visitors Visitors: 17
Members Members: 0
Total Total: 17

 
 Print   
  Contacts Minimize
 
 Print   
  Donations Minimize

If you have appreciated the time and effort that has gone into providing this site, you may wish to assist us by making a PayPal donation towards its running costs.

 
 Print   
  Excel Charting and Other Stuff Minimize
A collection of sample files on Excel Charting and more
Box Whisker Charts


How to build Box-Whiker Charts.

Uses a scatter chart to build box-whisker.



File size 491 K
Downloads 6
Date Mon 06/23/2008 @ 09:30
Author Ed Ferrero
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 6 times
Henderson Filter


One of my gripes when charting time series is that many people use simple moving averages to smooth data. A moving average does not reflect the underlying data as well as it is commonly supposed, and should always be shown together with the original data.

This add-in builds a 13-point Henderson filter. It is used to smooth monthly data that has annual periodicity. This method is preferred over a 13-month moving average, because it utilises lower weighting for the end-points of a time series. The resultant smoothed series shows turning points more accurately, and is better able to capture series maxima and minima.

The Henderson filter is the starting point for X-13 series decomposition as used by Government statistics bodies. Try it for your monthly data.



File size 13 K
Downloads 191
Date Wed 01/02/2008 @ 10:45
Author Ed Ferrero
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 191 times
Waterfall Chart


A waterfall chart built using scatter charts instead of the more common stacked column chart.

See my blog for more details.



File size 17 K
Downloads 176
Date Wed 12/26/2007 @ 08:53
Author Ed Ferrero
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 176 times
Variable Width Column Chart


One way of building a column chart with variable width columns.

File size 36 K
Downloads 450
Date Sat 05/26/2007 @ 12:11
Author SuperUser Account
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 450 times
Cascading Cell Validation


How to make the contents of one drop-down depend on the selection in another drop-down. This is done using cell validation based on a list. No VBA is required.

File size 78 K
Downloads 388
Date Sat 05/26/2007 @ 12:05
Author SuperUser Account
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 388 times
Interactive Balance Sheet


This shows how to use a Pivot Table to build a balance sheet. The nice thing about this is that the Balance Sheet is interactive, it allows drill-down and can show multiple periods together for comparison.

Just add your own Chart of Accounts and some data.



File size 94 K
Downloads 464
Date Fri 05/25/2007 @ 10:10
Author Ed Ferrero
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 464 times
Vary colour and Weight


Sample for road conditions chart. A line on a scatter chart changes colour according to a user-defined scale of values. The weight of the line is also set by the user, similarly to 'Format Chart Lines' above.

File size 6 K
Downloads 304
Date Thu 05/24/2007 @ 05:39
Author Ed Ferrero
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 304 times
Conditional Format Bar Chart


Shows how to apply conditional formatting to a bar chart.

File size 24 K
Downloads 683
Date Tue 05/15/2007 @ 03:08
Author Ed Ferrero
EMail ed@edferrero.com

RATING:   COMMENTS (1)  DOWNLOAD  Downloaded 683 times
Map Chart Europe


A sample chart showing how to plot small charts on various locations on a map. A royalty free map of Europe is used in this sample.

File size 206 K
Downloads 585
Date Mon 05/14/2007 @ 08:02
Author Ed Ferrero
EMail ed@edferrero.com

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 585 times
Forest Plots


Combines a clustered column chart with line charts over each cluster. This chart can only be drawn with a little VBA.

File size 26 K
Downloads 314
Date Mon 05/14/2007 @ 08:00
Author Ed Ferrero
EMail

RATING:   COMMENTS (0)  DOWNLOAD  Downloaded 314 times
< BACK  1 of 2  NEXT >
 
 Print   
    Minimize



Queensland MSDN User Group

 
 Print   
 
 
Terms Of Use  Privacy Statement