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.

Microsoft Excel is one of the most convenient and versatile programs small business owners can use for financial planning. Among the many charts and reports it can automatically generate from ...