Fill in the dialog box requesting input and output ranges for your data and other options. Otherwise, leave the Labels check box immediately below the Input X Range unchecked. If you have non-numeric labels in the Input X or Input Y ranges and have not checked the Labels box, you will see a error dialog box. If the first row in the input range includes labels, and if you have included these rows or columns in the Input ranges, check this box. If your input range does not include labels, leave this check box clear.
Most errors result from inappropriate ranges for input or output.
Check these boxes carefully and delete and retype if needed. The result is shown below. The series pattern can also be edited to display a different symbol for the predicted values. How to insert an Excel chart into a Microsoft Word document.