About MrExcel Consulting Services Learn Excel Resources Challenge of the Month MrExcel Seminars Message Board MrExcel Store Podcast Search Media Contact Home

Macroeconomic Supply Curve Charts

We're proud to present the world's best Supply Curve utility for Microsoft Excel. Using our MSCChart Add-In, you can easily create supply curve charts from your data in Excel.

Unlike other packages which provide a static picture of the supply chart in a dialog box, our version provides a fully editable Excel chart. You can add annotations, notes, and titles, just as in any other Excel chart.

A supply curve is a graphical representation of a supply schedule. The supply curve is drawn with prices plotted on the y-axis and the number of units of the good or service supplied along the horizontal axis. Where the law of supply applies to the particular market under consideration, the supply curve will slope (either gently or steeply) upwards from left to right.

The supply curve is different from a column chart. The width of each column in a supply curve chart indicates the number of units that the supplier was able to sell. This is not a chart type natively supported by Excel. The Engineering and Graphics Division of MrExcel.com Consulting developed this custom add-in using Visual Basic for Applications

Screen Shot of Supply Curve Chart

Creating the Supply Curve chart is easily accomplished with this simple dialog box.

The source data is shown below.

In 2006, the utility is improved as follows:
• Creates a native Excel chart – resizing the plot area will still keep the chart meaningful.
• You can format the colors of individual series like a normal Excel chart.
• It can tackle negative cost per unit values
• You can scale the y-axis

Supply Curve Pro: Break each cost column into Segments
While most supply curve charts show the cost as a single series, we had a request to produce a supply curve chart where each cost column could be broken into multiple components, such as Material, Labor, and Overhead. If you have a similar need, check out the Supply Curve Pro Version.
Return to MrExcel.com Consulting, MrExcel Engineering & Graphics Division or MrExcel.com Home

Last updated: October 16, 2007.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.