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.