how to show revenue increase in a chart on excel for mac

All you do is open the Excel worksheet with your historical data, position the cell cursor in one of its cells, and then click the Forecast Sheet button on the Data Tab of the Ribbon (AltAFC).

Simply click the Column Chart icon to the immediate right of the Line Chart icon at the top of the Create Forecast Worksheet dialog box.

For example, in the image below, the historical data table includes annual sales for the years 2000 through 2015, and Excel automatically uses this data to extend the forecast end date out four years to 2019.

When Excel cant automatically detect seasonality in your worksheet data, a warning appears that so advises you and suggests that you select the Set Manually option button (and leave the default setting at zero) to get better results in the forecast.

This new sheet contains a formatted data table that combines your historical data with the forecast values as well as an embedded line or column chart (depending upon your selection) depicting the trend in both the historical and forecast values.

As you can see, Excel placed this new forecast worksheet (named Sheet1) before the worksheet containing the historical data (named Annual Sales).

If you wanted, you could move this chart to its own chart sheet before saving the new forecast table and chart as part of the Historical and Forecast Sales workbook.

She is also a CompTIA A certified PC technician and an adjunct Computer Technology instructor at Purdue University.

Her online courses in Office applications and digital literacy have educated over a quarter of a million students for corporate clients.

How To Show Revenue Increase In A Chart On Excel For Mac