Related Articles
By convention, supply and demand graphs present price on the Y-axis and quantity on the X-axes. Excel will present these in reverse, so you need to modify the data on the Series tab. You also need to rename Quantity Supplied (Qs) from the schedule to Supply and Quantity Demanded (Qd) to Demand, as shown in the next three images.
- 1 Graph Linear Equations in Excel 2007
- 2 Explain Elasticity of Supply in Economic Terms
- 3 Distinguish Between a Demand Schedule & Demand Curve
- 4 What Are the Demand Schedule and the Demand Curve and How Are They Related?
Microsoft Excel provides several types of figures to display supply and demand information. The type of chart you use depends on what kind of analysis you want to conduct. If you want to find the equilibrium for supply and demand, the point at which both trends intersect, a line graph serves your needs. On the other hand, if you want to display the fluctuations between supply and demand, a column chart is more appropriate. Create your chart in Excel and then customize it with Excel's formatting tools.
1.Create a new Excel spreadsheet or open an existing spreadsheet that contains your supply and demand data. Label column A as 'Quantity' which will serve as your x-axis for both supply and demand data points. Label column B as 'Supply' and label column C as 'Demand.'
2.Input the quantity categories into each row of column A. Input all of your associated Supply data points into column B. Input all of your associated Demand data points into column C.
3.Create a line chart to display the trend lines of your supply and demand data. Highlight the data in column B and column C, select the 'Insert' tab of the Ribbon, and select the line chart with markers from the 'Line' drop-down box. Click the 'Select Data' button from the 'Design' tab, click 'Edit' under the 'Horizontal Axis Labels' text box and select the column A data.
4.Create a column chart to display the fluctuations between the supply and demand data. Highlight the supply and demand data, click the 'Insert' tab of the Ribbon and select the desired 'Column' chart. Click the 'Select Data' button from the Design tab, edit the horizontal axis and select the quantity data in the 'Axis Label Range' text box.
Tip
- Select a color scheme from the Design tab of the Ribbon that displays different colors for your Supply and Demand data. Different colors help your user to easily distinguish the difference between the two values.
References (1)
About the Author
Emily Ediger began writing professionally in 2007. Her work includes documenting technical procedures and editing event programs. Her expertise lies in technology, interactive learning and information retrieval. She holds a Bachelor of Arts in English from Portland State University.
Cite this Article Choose Citation Style
Ediger, Emily. 'How to Make Supply & Demand Figures in Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/make-supply-demand-figures-excel-29987.html. Accessed 20 October 2019.
Ediger, Emily. (n.d.). How to Make Supply & Demand Figures in Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/make-supply-demand-figures-excel-29987.html
Ediger, Emily. 'How to Make Supply & Demand Figures in Excel' accessed October 20, 2019. http://smallbusiness.chron.com/make-supply-demand-figures-excel-29987.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.