Overview

The attached file:

- defines key chart elements and explains how to edit them

- demonstrates how to deal with dates along the horizontal axis

- explains how to build dual-axes charts

- shows how to visually ‘transform’  the actual into forecast along the timeline

- describes how to create shaded areas on timeline charts

The file includes six chart examples accompanied by detailed step-by-step explanations on how to build them and interim chart versions.

Share
Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Dates and Timelines in Excel
544
34
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
Charts and Dashboards in Excel (short version)
647
68
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…
Analysing sensitivities with indifference curves (unlocked)
555
1
This is an unlocked version of the same utility published on my page. In this version you can access and…
Analysing sensitivities with indifference curves
544
58
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Portfolio Analysis and Sales Forecasting
989
2
The attached template provides the basis for product portfolio analysis as follows: - key statistics: total, average, median, standard deviation (total…
Form Controls and Other Interactive Tools
808
93
This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form…
See All