In this tutorial, we will show you exactly how to make a supply and demand graph in Google Sheets in just a few steps. Simply follow the steps below.
Follow the process below to use Google Sheets to make a supply and demand graph.
Start with a new, blank Google Sheet by clicking "+" This will be your workspace to enter the supply and demand data.
In the first column, enter the price values. In the second column, enter the supply quantity, and in the third column, enter the demand quantity.
Label the columns as "Price," "Supply Quantity," and "Demand Quantity."
Click and drag to select all three columns. This ensures that your data for price, supply quantity, and demand quantity will be included in the graph. After that, click "Insert."
Under the "Insert" tab, choose "Chart." This will create a basic chart using the selected data.
On the Setup tab under the Chart editor, click on "Scatter chart" to choose from the dropdown list.
Click on the "Line chart" to change the chart type.
Ensure both supply quantity and demand quantity series are included in the chart. The Chart Editor should automatically recognize them from your data. The price will be represented on the x-axis.
In the "Customize" tab, click "Chart & axis titles" to adjust the axis titles and colors. This will make the graph clearer and more visually appealing.
Label the graph “Supply and Demand” on the “Chart title” section.
Label the y-axis as "Quantity" in the “Vertical axis title” section.
Label the x-axis as "Price" in the “Horizontal axis title” section.
Check the final chart to ensure it accurately represents your supply and demand quantities along with the price. Make any last changes to improve clarity or appearance.
We hope that you now have a better understanding of making a supply and demand chart on Google Sheets. If you enjoyed this article, you might want to check our articles on how to use the SUMIF function on cells with color in Google Sheets and how to import multiple CSV files into Google Sheets.
