Thread: Graphing

Hello, Pete! Your request seems like a simple one, but it lacks some info: what is relation of quantity (X-axis) to rest of the data? I mean, demand of 130 at price of 100 is clear, but at what point of quantity it is?

Are they are connected with quantity in same order you wrote, so it is:

for quantity 20 and price 100, demand is 130 and supply 10

for quantity 40 and price 200, demand is 110 and supply 20

....

for quantity 140 and price 700, demand is 10 and supply 70?

EDIT: This appeared a bit tricky - if my assumption written above is correct, then quantity and price are linked in a unique way - for quantity 20, price may be only 100, etc. If that's correct, please take a look at attached file; though, if quantity and price vary independently, then you need either separate graph for each case of quantity or price (seven cases), either 3D graph, which, as far as I'm aware, is not available in standard set of graphs.

I feel you have your axes round the wrong way. The Y axis is typically the value axis. With a line chart, you would have your price as the category on the X axis and the supply and demand values plotted against that with data points against the Y axis.

See attached. If that's not what you want, draw a picture or provide a sample chart and attach that.

See attached.

Edit: one way to get the 100, 200 etc on the Y axis is to have a horizontal bar chart.

Another way is to use a XY scatter chart, which is basically the first chart flipped sideways.

See new attachment with all three and take your pick.

Select some data, create a XY Scatter chart. Don't worry how it looks initially. Edit the chart's source data. Define only two series. Select the Y Values and select the X values for each series from your data table.

cheers