An Excel pie chart displays categories of data as wedges in a circular graph. This format allows users to quickly see the contribution each category makes to the total figure and a correlation of ...

By selecting all three columns of data, you can select the type of chart from Excel's Insert tab. The most useful selection is a bar chart, because it allows you to format the second series as a line.

However, these charts are static. You could also consider creating Dynamic charts in Excel. By doing this, the curves in the graph would change as and when you change the value of the data.

The ease with which you can create a line graph in Excel on your PC or Mac will do much to dispel the misconception that the program is arcane and unapproachable. With just three clicks of a mouse ...