0
Here's an example of a basic Supply and Demand Graph:
- The Vertical Axis is always Price
- The Horizontal Axis is always Quantity
- There should be two lines, one for the supply curve and one for the demand curve, both of which represent different quantities at a particular price.
Here's some sample data:
| P | Qty D | Qty S |
|---|-------|-------|
| 4 | 95 | 40 |
| 5 | 90 | 65 |
| 6 | 80 | 80 |
| 7 | 60 | 90 |
| 8 | 50 | 100 |
| 9 | 45 | 110 |
When I try to map this in Google sheets as a Line chart with two series, it keeps adding price as the X-axis because that's the shared variable between the two, but price needs to be on the y-axis.
Sample Output (axes backwards):
This forum is asking the same question, but the links are dead