Friday, March 10, 2006

Creating a single line graph in Excel

Today I was asked a question from my friend as to how to add a single line graph in excel. That is how to display a line graph between price and quantity in excel with price in X-axis and quantity in Y-axis. When you select line graph in excel, that gives two line graphs one for quantity and one for price.

To arrive at a single line graph here is the procedure to follow. Enter the data into two coulmns of price and quantity as shown. Then select the two columns and click on chart wizard.

Select XY(Scatter) for Chart type. And the first one without any lines for the sub chart as shown. Click once on "Press and Hold to View Sample" to check whether the X-axis and Y-axis values look as what you are expecting. Then click next and change the X-axis and Y-axis values appropriately for both the series.

Then click on Finish. You get a range of dots which can then be connected by a line. To do this, click on chart and then on a "Add a trend line". Choose automatic and your line graph is ready.


Sandra M. said...

Thank-you! Despite everything I tried, the 'line' graph option in EXCEL (2010) would not allow a single x-versus-y line. Always graphed x and y as two lines against a time interval. This is nice, simple solution!

Its a wonderful life said...

Thanks a lot. I was wondering how to go about as excel automatically took me to a two line graph. If I do not have a directly proportional data, using the automatic trend line gives me a line in between the data. So I used the scatter with smooth lines and marker. Is that ok?

Its a wonderful life said...

Thanks a lot . Was wondering how to get a single or get excel to let me define x and y axis to avoid a two line graph. If my data is not linear , I get a trend line in the midst of the data. In such a case , is using the next option of scatter with smooth lines and markers ok? .

Databases and Data Visualisations Course for kids Week 1

As mentioned last week, I have started the Databases and Data Visualisations course for kids aged between 11 to 15 years yesterday. It was...