Excel Charts

BCG Matrix

Demonstrates how to create a bubble chart where the bubbles are themselves pie charts. The workbook is useful in its own right for BCG portfolio analysis (Boston Consulting Group). The technique shown here can be used with other types of charts, turning each point in a chart series to an individual pie or other chart. This is one of those "they said it couldn't be done" charts.

File size	44 K
Downloads	4558
Date	Mon 02/02/2009 @ 11:47
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (9) DOWNLOAD Downloaded 4558 times

Wind Rose

How to build a wind rose. Converts compass directions to degrees and radians, and plots a nice-looking chart

File size	17 K
Downloads	1974
Date	Mon 05/14/2007 @ 07:46
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (0) DOWNLOAD Downloaded 1974 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	1962
Date	Mon 05/14/2007 @ 08:02
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (0) DOWNLOAD Downloaded 1962 times

Conditional Format Bar Chart

Shows how to apply conditional formatting to a bar chart.

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

RATING: COMMENTS (1) DOWNLOAD Downloaded 1718 times

Reporting

Demonstrates a good way of showing monthly report data. The chart series can be selected from a drop-down. Chart data updates automatically. Data can reside in the same workbook, or be stored on a separate workbook. The workbook does not use VBA, just demonstrates good layout and the use of OFFSET functions.

File size	25 K
Downloads	1616
Date	Mon 05/14/2007 @ 07:44
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (2) DOWNLOAD Downloaded 1616 times

Speedometer

A little bit of code attached to a chart, makes an interesting way to present data.

File size	6 K
Downloads	1519
Date	Mon 05/14/2007 @ 07:53
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (1) DOWNLOAD Downloaded 1519 times

Map Charts - USA

A mini application demontrationg how to use a scatter chart to show various statistics on any map. This comes with a simple (and royalty free) map of the USA.

File size	107 K
Downloads	1381
Date	Thu 04/05/2007 @ 12:39
Author	SuperUser Account
EMail	ed@edferrero.com

RATING: COMMENTS (0) DOWNLOAD Downloaded 1381 times

Chart Selector Version 2

Same as 'Chart Selector' on these pages, but using drop-downs and dynamic ranges. This workbook does not use VBA at all, but shows how to select chart series using a simple drop-down control. A technique to dynamically transpose a range is also shown.

File size	12 K
Downloads	1252
Date	Mon 05/14/2007 @ 07:51
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (0) DOWNLOAD Downloaded 1252 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	1089
Date	Fri 05/25/2007 @ 10:10
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (0) DOWNLOAD Downloaded 1089 times

Variable Width Column Chart

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

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

RATING: COMMENTS (0) DOWNLOAD Downloaded 1057 times