answersLogoWhite

0

Enter two data series that correspond and select them. On the Data tab, in the Forecast group, click Forecast Sheet. In the Create Forecast Worksheet box, pick either a line chart or a column chart for the visual representation of the forecast. Pick an end date, and then click Create. This will create a new worksheet with your forecast and a chart. You can also use the FORECAST function.

User Avatar

Wiki User

7y ago

What else can I help you with?

Related Questions

Why is MS Excel is called Excel?

MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.


How do you calculate sharpe ratio in Excel?

The related link provides an excel template and some notes on how to calculate the sharpe ratio..pretty simple and effective.


What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


How do you calculate degrees of freedom on excel?

Utilizing the visual basic functions built into excel worksheets you can calculate degrees of freedom. The function call that you use for this is "degrees_freedom".


What is scenario in Microsoft Excel?

a scenrious ia a set of values , which are saved by excel , and later substituted automatically in your worksheet . it s used when you are not sure of the outcome , so you can forecast the outcome of worksheet model.


What is the use of MS excel 2007?

you may calculate


How do you calculate treynor ratio in Excel?

calculate the effective return (mean return minus the risk free rate) divided by the beta. the excel spreadsheet in the related link has an example.


How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?

Calculating DSCR in Excel sheet


How to calculate percentage achievement in sales?

Divide the total sales by the total sales forecast


On Microsoft Excel what do you need to write to calculate things?

Formulas.


What is Cash Flow Excel and what does it do?

Cash Flow Excel are spreadsheets created by excel to help manage your money. They calculate balances on accounts as well as help you to budget your money effectively.


How do you calculate a discount in Microsoft Excel?

See the explanation in the related link.