I would like to set up a supply and demand chart with the equilibrium price
automatically calculated and the point set in the chart, plus the lines for
all the shifts in supply or demand. Thank ou.

Sure, I can help you with that! Here are the steps to set up a supply and demand chart with the equilibrium price automatically calculated:

1. Open a new Excel worksheet and enter your data. In this case, you'll need to enter the quantity demanded and supplied at different prices. You can create two columns for this data, one for quantity and one for price.
   
2. Highlight the data you just entered and click on the "Insert" tab at the top of the screen. Then, click on the "Scatter" chart type and select the chart style you prefer.
   
3. Right-click on the chart and select "Select Data" from the drop-down menu. In the "Select Data Source" dialog box, click on the "Add" button to add a new series.
   
4. In the "Edit Series" dialog box, enter a name for the series (e.g. "Equilibrium Price") and select the cell that contains the equilibrium price calculation. Then, click "OK" to close the dialog box.
   
5. Right-click on the new series in the chart and select "Change Series Chart Type" from the drop-down menu. Select the "Line" chart type and click "OK".
   
6. To add the lines for shifts in supply or demand, you can add additional series to the chart using the same steps as above. Just make sure to label each series appropriately and select the correct cells for the data.
   
7. Finally, you can customize the chart as desired by adding titles, labels, and formatting options. You can also adjust the axis scales and ranges to better display the data.

That's it! You should now have a supply and demand chart with the equilibrium price automatically calculated and the lines for shifts in supply or demand. Let me know if you have any questions or need further assistance.

Drawing Supply and Demand curves in Excel
http://www.tushar-mehta.com/excel/ch...ly_and_demand/

On Sat, 31 Oct 2009 14:04:01 -0700, Edin
wrote:

I would like to set up a supply and demand chart with the equilibrium price
automatically calculated and the point set in the chart, plus the lines for
all the shifts in supply or demand. Thank ou.
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins