How to Create a Demand and Supply Chart in Excel

128 Comments / Blog, Business, Data Analysis, Economics, Excel / By

Demand Curve in Excel

Demand Curve
Demand curve created in Excel

Supply Curve in Excel

Table of demand and supply curve base on price
Supply Curve
Supply Curve in Excel
Demand and supply curve, showing eq point

Description of the Chart:

The demand and supply chart illustrates the relationship between the price of a product or service and the quantity demanded and supplied in a market. In this chart, the demand curve represents the quantity of a good or service that consumers are willing and able to purchase at different price levels, while the supply curve represents the quantity of the same good or service that producers are willing and able to supply at different price levels.

As the price of the product increases, the quantity demanded generally decreases, resulting in a downward-sloping demand curve. Conversely, as the price increases, the quantity supplied generally increases, resulting in an upward-sloping supply curve. The point at which the demand and supply curves intersect represents the equilibrium price and quantity, where the quantity demanded equals the quantity supplied.

Method to Create the Chart in Excel:

  1. Enter Data:
    • Input the price and corresponding demand and supply quantities into an Excel spreadsheet. Place the price values in one column, the demand quantities in another column, and the supply quantities in a third column.
  2. Select Data:
    • Select the range of cells containing the data (including the price column, demand quantity column, and supply quantity column).
  3. Insert Chart:
  1. Go to the ‘Insert’ tab on the Excel ribbon.
  2. Click on the ‘Insert Line or Area Chart’ button and choose the ‘Line’ chart type.
  3. Select the ‘Line with Markers’ chart subtype to display both lines with data points.
  4. Customize Chart:
  1. Right-click on the chart area and select ‘Select Data’.
  2. Click ‘Edit’ under ‘Horizontal (Category) Axis Labels’ and select the range of cells containing the price values.
  3. Adjust the chart title, axis labels, legend, and other formatting options as desired to improve readability and clarity.
  4. Add Chart Elements:
    • Consider adding a title to the chart describing the relationship (e.g., “Demand and Supply Chart”).
    • Label the axes clearly, indicating the price and quantity.
    • Add a legend to distinguish between the demand and supply curves.
  5. Analyze and Interpret:
    • Analyze the chart to identify the equilibrium price and quantity, where the demand and supply curves intersect.
    • Interpret the relationship between price and quantity demanded and supplied, noting any shifts or movements in the curves.

By following these steps, you can create a demand and supply chart in Excel to visually represent the relationship between price and quantity in a market.

https://datatipss.com/category/excel

Related Posts

128 thoughts on “How to Create a Demand and Supply Chart in Excel”

  5. Mike Ryder

    Hi there,

    My name is Mike from Monkey Digital,

    Allow me to present to you a lifetime revenue opportunity of 35%
    That’s right, you can earn 35% of every order made by your affiliate for life.

    Simply register with us, generate your affiliate links, and incorporate them on your website, and you are done. It takes only 5 minutes to set up everything, and the payouts are sent each month.

    Click here to enroll with us today:
    https://www.monkeydigital.org/affiliate-dashboard/

    Think about it,
    Every website owner requires the use of search engine optimization (SEO) for their website. This endeavor holds significant potential for both parties involved.

    Thanks and regards
    Mike Ryder

    Monkey Digital

    Reply
  22. LhaneDrugh

    Hi there I am so glad I found your blog page, I really found you by accident, while I was searching on Aol for something else, Anyways I am here now and would just like to say thanks for a remarkable post and a all round thrilling blog (I also love the theme/design), I don’t have time to read through it all at the minute but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read much more, Please do keep up the awesome work.
    http://www.diplomans-rossian.ru

    Reply
  29. Sight Care reviews

    I have been absent for a while, but now I remember why I used to love this blog. Thanks , I¦ll try and check back more frequently. How frequently you update your web site?

    Reply
  40. Pro Nerve 6

    I’m not sure where you’re getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for magnificent info I was looking for this information for my mission.

    Reply
  47. Fitpsresso

    I feel this is one of the so much important info for me. And i am glad studying your article. But want to observation on some common issues, The web site taste is ideal, the articles is in reality nice : D. Excellent task, cheers

    Reply
  48. Boostaro

    After examine a number of of the weblog posts in your website now, and I really like your way of blogging. I bookmarked it to my bookmark website listing and can be checking back soon. Pls try my website online as nicely and let me know what you think.

    Reply
  53. Zencortex

    An impressive share, I just given this onto a colleague who was doing a little analysis on this. And he in fact bought me breakfast because I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading more on this topic. If possible, as you become expertise, would you mind updating your blog with more details? It is highly helpful for me. Big thumb up for this blog post!

    Reply
  54. Tonic Greens

    I was recommended this web site by my cousin. I am no longer positive whether this publish is written through him as no one else realize such precise about my trouble. You are wonderful! Thanks!

    Reply
  55. Fitspresso review

    Some truly superb info , Gladiola I discovered this. “I know God will not give me anything I can’t handle. I just wish that He didn’t trust me so much.” by Mother Theresa.

    Reply
  58. prodentim

    Prodentim is the most recent dental health product. It helps to maintain healthy gums by using an ingredient that dentists at ProDentim UK developed.

    Reply
  59. prodentim review

    I am curious to find out what blog system you are working with? I’m experiencing some small security issues with my latest blog and I’d like to find something more safe. Do you have any solutions?

    Reply
  62. zoritoler imol

    Howdy! This post could not be written any better! Reading through this post reminds me of my good old room mate! He always kept talking about this. I will forward this page to him. Fairly certain he will have a good read. Many thanks for sharing!

    Reply
  63. diplompyday

    Делаем отличное предложение вам сделать консультацию (аудит) по усилению продаж а также прибыли в вашем бизнесе. Формат аудита: личная встреча или конференция по скайпу. Делая очевидные, но не сложные усилия, прибыль от ВАШЕГО коммерциала удастся превознести в много раз. В нашем запасе более 100 проверенных фактических методик увеличения продаж а также доходов. В зависимости от вашего коммерциала расчитаем для вас наиболее наилучшие и будем постепенно внедрять.
    – interestbook.ru

    Reply
  64. Prodentim

    Hi my friend! I want to say that this article is awesome, nice written and include approximately all significant infos. I would like to see more posts like this.

    Reply
  70. Java Burn review

    Thank you, I’ve just been searching for info approximately this topic for a while and yours is the best I’ve found out so far. But, what concerning the conclusion? Are you positive about the source?

    Reply
  71. Lottery Defeater

    You can definitely see your skills in the paintings you write. The sector hopes for even more passionate writers such as you who aren’t afraid to mention how they believe. All the time follow your heart.

    Reply
  72. Puravive

    Excellent post. I was checking constantly this blog and I’m impressed! Very helpful information specially the last part 🙂 I care for such information a lot. I was seeking this certain info for a long time. Thank you and good luck.

    Reply
  73. LeanBiome

    I do like the way you have framed this particular challenge plus it does provide me personally some fodder for consideration. On the other hand, coming from everything that I have witnessed, I simply just hope when the feedback stack on that people stay on point and in no way get started upon a soap box of some other news of the day. Yet, thank you for this outstanding point and though I can not really agree with it in totality, I regard your standpoint.

    Reply
  74. Java Burn review

    Hi there, I found your blog by the use of Google whilst searching for a similar subject, your web site got here up, it seems to be good. I have bookmarked it in my google bookmarks.

    Reply
  75. Kerassentials

    I just like the helpful info you provide in your articles. I will bookmark your blog and check again right here frequently. I am relatively certain I will learn lots of new stuff right right here! Good luck for the following!

    Reply
  77. empresa inca

    It is appropriate time to make a few plans for the future and it is time to be happy. I’ve learn this put up and if I could I desire to counsel you few fascinating things or advice. Perhaps you can write subsequent articles relating to this article. I want to read even more issues about it!

    Reply
  78. Fitspresso review

    Thanks for another magnificent article. The place else could anybody get that type of information in such a perfect approach of writing? I’ve a presentation next week, and I’m on the look for such info.

    Reply
  79. ethical hackers for hire

    Having read this I thought it was very informative. I appreciate you taking the time and effort to put this article together. I once again find myself spending way to much time both reading and commenting. But so what, it was still worth it!

    Reply
  81. Vincenzo Trefz

    Hello! This is my 1st comment here so I just wanted to give a quick shout out and say I genuinelyenjoy reading your articles Can you recommendany other blogs/websites/forums that go over the same topics?Thank you so much!

    Reply
  82. Cogni Care pro

    I¦ve been exploring for a little for any high quality articles or weblog posts in this kind of house . Exploring in Yahoo I at last stumbled upon this web site. Studying this information So i¦m happy to show that I’ve an incredibly just right uncanny feeling I found out exactly what I needed. I so much no doubt will make sure to do not disregard this website and provides it a glance regularly.

    Reply
  84. Java Burn

    Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why throw away your intelligence on just posting videos to your site when you could be giving us something informative to read?

    Reply
  85. Java Burn Review

    obviously like your website however you need to test the spelling on quite a few of your posts. Several of them are rife with spelling problems and I find it very bothersome to tell the truth then again I will certainly come again again.

    Reply
  88. Java Burn

    hello!,I like your writing so much! share we communicate more about your post on AOL? I need a specialist on this area to solve my problem. May be that’s you! Looking forward to see you.

    Reply
  91. fitspresso

    What i do not realize is in fact how you are no longer actually a lot more well-liked than you may be now. You are so intelligent. You know therefore considerably on the subject of this topic, made me individually imagine it from numerous varied angles. Its like men and women are not interested unless it is one thing to accomplish with Girl gaga! Your own stuffs outstanding. All the time take care of it up!

    Reply
  92. Tonic Greens

    hi!,I like your writing so so much! proportion we communicate extra about your article on AOL? I need an expert on this space to solve my problem. Maybe that is you! Looking forward to look you.

    Reply
  96. provadent

    Magnificent beat ! I wish to apprentice while you amend your website, how can i subscribe for a blog website? The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear concept

    Reply
  97. quietum plus

    I just could not depart your site before suggesting that I extremely enjoyed the standard info a person provide for your visitors? Is going to be back often to check up on new posts

    Reply
  99. Nano defense pro

    Hello! I just want to give an enormous thumbs up for the good information you could have right here on this post. I will likely be coming back to your blog for extra soon.

    Reply
  100. pediatric physical therapy orlando fl

    I absolutely love your blog and find the majority of your post’s to be just what I’m looking for. can you offer guest writers to write content in your case? I wouldn’t mind creating a post or elaborating on a lot of the subjects you write about here. Again, awesome website!

    Reply
  101. SightCare

    Thanks for sharing excellent informations. Your website is so cool. I’m impressed by the details that you have on this blog. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for more articles. You, my friend, ROCK! I found just the info I already searched all over the place and just could not come across. What a perfect website.

    Reply
  102. hire a hacker dark web

    There are certainly numerous details like that to take into consideration. That is a great level to convey up. I provide the ideas above as normal inspiration but clearly there are questions just like the one you convey up where crucial thing will be working in honest good faith. I don?t know if greatest practices have emerged around issues like that, however I am certain that your job is clearly recognized as a fair game. Each boys and girls feel the impact of only a moment’s pleasure, for the rest of their lives.

    Reply
  105. Cellucare Reviews

    I have been browsing online more than three hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my view, if all web owners and bloggers made good content as you did, the internet will be a lot more useful than ever before.

    Reply
  107. hire an instagram hacker

    My wife and i were so fulfilled when Peter managed to complete his basic research through the entire precious recommendations he came across out of the weblog. It’s not at all simplistic just to find yourself making a gift of concepts which most people might have been making money from. We already know we need the writer to appreciate for this. The illustrations you made, the straightforward web site navigation, the friendships your site assist to engender – it’s many great, and it’s really letting our son and us understand that article is interesting, and that is seriously vital. Thanks for all!

    Reply
  109. The Genius Wave

    I think this is one of the most important information for me. And i am glad reading your article. But want to remark on some general things, The site style is ideal, the articles is really nice : D. Good job, cheers

    Reply
  110. Sugar Defender

    I really wanted to construct a brief comment in order to say thanks to you for all of the lovely suggestions you are showing on this site. My considerable internet look up has finally been compensated with professional facts to write about with my co-workers. I ‘d declare that many of us website visitors actually are quite blessed to live in a magnificent network with many awesome professionals with helpful secrets. I feel pretty lucky to have seen the weblog and look forward to tons of more fabulous minutes reading here. Thanks a lot once again for a lot of things.

    Reply
  112. cell phone hackers for hire

    Thank you for the sensible critique. Me and my neighbor were just preparing to do some research on this. We got a grab a book from our area library but I think I learned more clear from this post. I’m very glad to see such fantastic information being shared freely out there.

    Reply
  114. tonic greens

    I have learn several excellent stuff here. Certainly value bookmarking for revisiting. I wonder how a lot effort you set to make this type of magnificent informative website.

    Reply
  115. nitric boost

    hi!,I really like your writing very a lot! proportion we keep in touch extra approximately your post on AOL? I need a specialist in this space to solve my problem. Maybe that’s you! Taking a look ahead to look you.

    Reply
  116. white hat hackers for hire

    I’m really enjoying the theme/design of your weblog. Do you ever run into any browser compatibility problems? A few of my blog visitors have complained about my blog not working correctly in Explorer but looks great in Safari. Do you have any advice to help fix this problem?

    Reply
  126. customer journey

    Nice post. I learn something more challenging on different blogs everyday. It will always be stimulating to read content from other writers and practice a little something from their store. I’d prefer to use some with the content on my blog whether you don’t mind. Natually I’ll give you a link on your web blog. Thanks for sharing.

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *

Subscribe
Subscribe