The best way to graph a supply and demand curve in Microsoft Excel would be to use the XY Scatter chart. A line graph is good when trying to find out a point where both sets of data intersects. A column chart is good for displaying the variation between the data.Continue Reading
To graph a supply and demand curve in Microsoft Excel in both versions 2010 and 2013, follow these steps. Replace the data used in the example below with the data that is available to you.