How to Make a Curved Line Graph in Excel

Curved line graph - ITAU

One of the popular types of graphs that can be made with Excel are Line Graphs. Line graphs are usualy used to track changes over a specified period of time. For example, when tracking changes in weather patterns over a period of 12 months, a line graph would be ideal.

Read also: ITAU Workshops to attend this year.

Personally, I use line graphs to track enrollment patterns at E-zone School of Computing in Nabbingo.

Read also: Software every school computer lab should have.

However, of recent, I was asked by one of my students why the line graphs where always straight from one point to the next. The student asked me how he could add a curve or bend to a particular line graph. Today’s article explains this and I hope it could help you too.

Select the data and create a normal line graph

Right click on the line graph and choose Format Data Series

Click on the bucket

Scroll to the bottom and click to activate Smoothed line.

You now have a smoothed line graph.

You can post any other such challenges in the comments section below or chat with an ITAU executive by clicking on the WhatsApp button at the bottom of your screen. An article will be written to help you and others.

____________________________


Stephen Dumba is the co-ordinator, Central Region ICT Teachers’ Association of Uganda. He owns E-zone Internet Cafe, E-zone School of Computing and co-director E-zone Web Services. He can be reached on +256 772 111 223 or +256 752 111 223.

____________________________