How do I set up a normal graph?

  • Thread starter Thread starter Ahir
  • Start date Start date
A

Ahir

I want to set up a simple demand and supply graph in Excel.

All the points are given and i need not to fix any formulae for my data

sets. All I want is to get a graph with x-axis (being quantity) and y-axis

(being price in pounds).
 
Go to Insert - Chart.

Choose an XY scatter graph (depending on how you want it displayed)
Highlight the data you are using, and then customize as desired.
 
Ahir,

Go to Insert=>Charts=> Choose which ever chart type you require=Then select
the range you want to show in the chart=> The chart will be presented in the
window (if the chart is as per your requirement Press Finish).

Then right click on the chart area and select chart options.
Chart Options=>Title (Tab)=> Give a title to the chart => then on X-axis
comment box you can name the items represented=>on Y-axis comment box you can
type pounds. The range of pounds is automatically reflected by excel. Then
yes OK.

Your chart is done

Let me know if i am wrong.

Thanks
 
Back
Top