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	6231
Date	Mon 02/02/2009 @ 11:47
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (10) DOWNLOAD Downloaded 6231 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	2652
Date	Mon 05/14/2007 @ 07:46
Author	Ed Ferrero
EMail	ed@edferrero.com

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

RATING: COMMENTS (0) DOWNLOAD Downloaded 2490 times

Conditional Format Bar Chart

Shows how to apply conditional formatting to a bar chart.

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

RATING: COMMENTS (1) DOWNLOAD Downloaded 2209 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	2023
Date	Mon 05/14/2007 @ 07:44
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (2) DOWNLOAD Downloaded 2023 times

Speedometer

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

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

RATING: COMMENTS (1) DOWNLOAD Downloaded 1926 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	1780
Date	Thu 04/05/2007 @ 12:39
Author	SuperUser Account
EMail	ed@edferrero.com

RATING: COMMENTS (0) DOWNLOAD Downloaded 1780 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	1574
Date	Mon 05/14/2007 @ 07:51
Author	Ed Ferrero
EMail	ed@edferrero.com

RATING: COMMENTS (0) DOWNLOAD Downloaded 1574 times

Variable Width Column Chart

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

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

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

RATING: COMMENTS (0) DOWNLOAD Downloaded 1303 times