How to create a Demand and Supply graph in Excel (for ...
How to create a Demand and Supply graph in Excel (for Dummies!)
Nikos Tzivanakis November 10, 2018
1 Create a graph in Excel
Step 1: Open an Excel Worksheet. Step 2: Create 4 columns for Price, Demand and Supply (the 4th one should be for the change you will discuss in
your assignment)
Step 3: Add data in your columns. You can either use a demand and a supply equation to generate the data or put random numbers. Remember that they need to obey the laws of demand and supply.
1
Step 4: Select your data Step 5: Click the "Insert" Tab in Excel.
Step 6: Click the arrow next to the option "Insert Scatter (X,Y)" and then select the option "Scatter with straight lines". Now you have a graph but there is a small issue. Excel has put the price on the horizontal axis and quantity on the vertical one. We need to fix it.
Step 7: Right-click on the graph and select the option "Select Data. . . " 2
Step 8: In the new menu that appears select the demand curve and click edit.
Step 9: Now we need to switch the contents in the "Series X Values" with the one in "Series Y values". You can either copy-paste the contents to the other cell deleting the original content afterwards or delete the content and select from your data the cells that include the quantity demanded in the X axis and price in the Y axis as I demonstrate in the pictures below. Pictures
3
Step 10: Repeat the process for the supply cruve and your new demand or supply curve, depending on what change you choose to discuss. (Demand 2 in my example).
Step 11: Now you can click on the top right side of the graph the + sign to tweak the lines and the appearance of the axes names. You can also tweak the colour of the lines and fonts.
4
Step 12: Once you finish right-click the graph and select copy.
Step 13: Open your Word document with your assignment and right-click and paste your graph as a picture.
There are more things you can do in Excel, if you feel comfortable play around with it. 5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- guidelines how to make figures and
- brief tutorial on using excel to draw an x y plot
- how to create graphs with a best fit line in excel
- cutting and pasting graphs from excel to word
- creating charts graphs in excel powerpoint
- last accessed 9 5 2019 appendix iii using excel to graph
- a resource for free standing mathematics units graphs of
- activity graphicalanalysis excel loggerpro editgf
- how to create a demand and supply graph in excel for
- graphing tips for microsoft excel 2010 pc
Related searches
- how to create a macro in excel
- how to create a checklist in excel
- how to create a sign in sheet
- how to create a spreadsheet in excel
- how to create a barcode in excel
- how to create a formula in excel
- how to create a excel spreadsheet
- how to create a string in matlab
- how to create a dataset in r
- how to create a tuple in python
- how to create a list in java
- how to create a vector in matlab