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
The source data is shown below.
In 2006, the utility is improved as follows:
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 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.